Excel offers a wonderful function that allows you to quickly format a table in a variety of styles. You must click the table after selecting the Insert tab in order to access this function. The table templates are available here.
In contrast to a conventional Excel table, formatting can provide you more options, like filtering and sorting your data as well as calculations. However occasionally you might want to get rid of these functionalities.
How To Remove Formatting
Use the instructions below for removing formatting:
Step
Getting Rid Of The Sorting And Filtering Options
If your table has filtering and sorting options and you want them deleted, we’ll start by looking at how to remove them.
Step
Adapt To Range
Click anywhere within the edges of your table. After that, click Convert To Range under Table Design, which can be found at the top of the page (some Excel versions will have a Design label).
Make sure you really want to change it to a typical range. By doing this, all sorting and filtering associated with table formatting will be eliminated.
Step
Choose All of the Table
Select the entire table by dragging the mouse and holding it over each cell to eliminate any formatting.
Step
Take Away All Formats
Then, select Editing from the Home tab. A tiny eraser icon can serve as a representation for this.
After clicking this button, choose Delete All Formats. Now that all the formats in your table have been eliminated, all that should be left is a table containing your written or numerical data.
Click on a cell in your table to see if the formulas have been changed to the way they are normally referenced to see if this has been done correctly. Your formula should include references to the sheet’s cells, such as =sheet1$D2/sheet1$C2 in order for this to make sense.
How To Revert Back To A Table
Below are the detailed instructions for returning to a table.
Step
choosing a table
By going to the Insert tab and selecting table, you can get the table back if you decide to change your mind.
Step
Press “OK”
Verify that the cells have been correctly highlighted before clicking “OK” to ensure that Excel has not overlooked any of the intended table’s cells.
The table will automatically format when you click Ok, but keep in mind that it could not be exactly in the same format as previously. You can use the procedures we previously outlined and click one of the cells to find the formula to see if this is the case.
Step
Table not properly formatted
There are two ways to fix a formatted table if it has been done incorrectly.
Reentering the formula manually into the required cells is the first step. This approach has the drawback of taking longer, especially if you have a lot of data and a lot of cells to modify.
The second choice is to select a table format from the prepared selection by clicking the Table Design tab.
The first choice that will be shown to you is the basic table. By doing so, you will be able to create a table with all of the functionality but none of the layout.
Important Points
Please be aware that after creating your table, Excel has a gallery of custom table styles that you can choose from.
A custom style table, on the other hand, is only available in the current workbook and won’t be present in subsequent workbooks if you need one.
Final Thoughts
It’s simple to format a table, and it’s simple to undo table formatting. By using the preceding advice, you may govern your Excel tables considerably more effectively and without as much confusion.