Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • OneDrive
      • Google Docs
      • Google Sheets
      • Google Drive
    • Email
      • Gmail
      • Outlook
      • Emal Etiquette
    • Office Etiquette
    • Productivity
    Inside The Web
    Home»Office»Excel»How to Remove Table Format in Excel

    How to Remove Table Format in Excel

    Nisha GurungBy Nisha GurungJune 19, 2023 Excel 4 Mins Read

    When you create a table in Excel, you’ll be prompted to choose from various pre-built styles for your data. Be it a regular Table or PivotTable, you’ll mainly find grey and colorful banded rows designs in the gallery.

    However, if just want to use the table functionality without any styles, you can clear the applied format anytime. Apart from removing the format, you could also completely turn off the table for your data.

    In this article, let’s learn how to remove a table as well as its formatting from your sheet.

    Clear Table Formatting

    If you only want to remove the table formats like shaded rows from your data, this method is for you. Here, we will use the Clear option to delete the format in several tables.

    Note: Even if you delete formatting, you can still access all the table features such as Filter, Column headings, Auto-table extensions after adding data, etc.

    To do so, click on any cell within the Table and head to the Table Design tab. On Table Styles, click on the More icon to expand the table styles. Then, choose Clear.

    Use Clear Format

    Another way to delete your table format is by using the Clear Format. It does a pretty similar job to the Table design’s Clear menu. But, here, we will use the keyboard shortcut to do so.

    NOTE: Clear Format will remove entire formats in your data. If you’ve applied other formats, this method might not be appropriate for you.

    Firstly, place your cursor on one of the Column headers and select the Table ranges using Ctrl + A. Then, press down the following shortcut. Remember, as it is a Ribbon shortcut, you can enter each key at a time. Suppose, you enter the Alt key. Then, after releasing it, press the H key, and so on.

    Shortcut key: Alt + H + E + F

    Convert Table to Range

    If you want to permanently get rid of the table from your data, there’s no such default Remove Table option to do so. So, most users often struggle with this part.

    But, the trick to turn off the table is to convert your data into a range. This way, you will have only values in the sheet and lose table functionality.

    1. Select the Table and right-click on it. 
    2. From the context menu, click on Table > Convert to Range.
      From the context menu, click on Table -Convert to Range
    3. On the Prompt box, pick Yes to confirm.
      On the Prompt box, pick Yes to confirm

    Alternatively, you can also change your table to range from Excel Ribbon. For this, select the cell in the table and head to the Table Design tab. From the Tools section, click on Convert to Range and choose Yes on the prompt box. 

    Use Copy Paste Command

    Using Excel’s Copy Paste command is one more alternative to completely remove the table. This approach is effective if you want to keep the table format intact in the original data. But, disable the table for only a few information. 

    Here, we have copied certain values from the table and pasted them into the new area within the same sheet. However, you could also paste them into a new sheet.

    1. Select the cell ranges within your table and enter Ctrl + C to copy the selected area.
      Select the cell ranges within your table and enter Ctrl + C to copy the selected area
    2. Right-click in a new cell. Under Paste Options, pick Values.
      ight-click in a new cell. Under Paste Options, pick Values 
    Quick tip: When you hover over each Paste icon, you can see the Paste Option name.

    Related Questions

    How to Remove the Table Format From PivotTable?

    There’s a similar Clear option to remove the shaded rows and columns in PivotTable too. However, unlike other tables, you can find the menu in the Design Tab instead. To delete the format, click on the PivotTable area and head to Design Tab. On PivotTable Styles, expand the More icon and choose Clear.

    Excel Basics
    Nisha Gurung

      As a Business Student, Nisha first used Excel to outline data trends for her college projects. Later, she started exploring basic Excel functions when she realized it is a powerful tool for all businesses today. Nisha believes she can relate to many of the issues users face when starting their Excel Journey. She uses this knowledge and experience to curate contents that are fit for all types of Excel users. Apart from writing, she enjoys reading books and traveling.

      Related Posts

      Excel By Nisha Gurung

      How to Compare Two Columns in Excel Using VLOOKUP

      Excel By Nisha Gurung

      How to Share Excel Files with Multiple Users

      Excel By Nisha Gurung

      How to Filter Based on a List in Excel

      Add A Comment
      Table of ContentsToggle Table of ContentToggle
      • Clear Table Formatting
      • Use Clear Format
      • Convert Table to Range
      • Use Copy Paste Command
      • Related Questions
        • How to Remove the Table Format From PivotTable?
      • Home
      • About Us
      • Privacy Policy
      © 2025 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.