- #HOW TO CLEAR FORMATTING IN WORD 2013 MAC HOW TO#
- #HOW TO CLEAR FORMATTING IN WORD 2013 MAC MAC#
- #HOW TO CLEAR FORMATTING IN WORD 2013 MAC WINDOWS#
That's how to clear table formatting in Excel. From the functional viewpoint, however, it is a usual range - all features of Excel table such as structured references, automatic expansion, inbuilt filters, etc. In the result, your data will still look very much like a table because the table style formatting is preserved.
In the context menu, click Table > Convert to Range.Ī prompt will show up asking if you really want to convert the table to a normal range, and you click Yes. In case you no longer need data formatted as a table, here's how you can remove a table format and turn it into a regular range of cells: How to remove format as table in Excel (convert table to range) Please keep in mind that this method clears all formatting entirely, including number formats, alignment, etc. 
On the Home tab, in the Editing group, click Clear > Clear Formats.Īs the result, all formatting in a table is removed:. Click any cell within a table, and then press Ctrl + A twice to select the whole table including the headers. To clear absolutely all formatting (both predefined and your own one), carry out these steps: Remove the footer: If you want to remove all information contained in the footer, click the Footer command and select Remove Footer from the menu that appears. If the above-mentioned approach has not removed all the formatting in your table, that means the remaining part is your custom format that was done manually. right-click on the style you want to delete, then select Delete 