#Clear all formatting excel shortcut how to#

Select the first option in the menu which is None.Go to the Table Design tab and open the Table Styles menu by clicking on the dropdown arrow.Let’s use this elusive tab to remove Table formatting from an Excel Table: Don’t worry if you can’t find the Table Design tab when you look at your file the tab appears only when the active cell is in a Table. This is done in a few clicks from the Table Styles menu in the Table Design tab. Only the formatting will be removed the Table stays with all its functions. The steps below will remove the Excel Table formatting.

#Clear all formatting excel shortcut how to#

How to Remove Excel Table Formatting (While Keeping the Table) This quick guide covers both the scenarios above and also a small section on how to clear all formatting from a Table down to default plain text. In those cases, you can retain the Table’s formatting as it is and delete the Excel Table. Or you are done with your work on your Table, need to pass the file around but don’t intend for the user to access the data as a Table. Basically, you’d want to make your dataset a pretty range which is going into print and there is no need of a Table anymore. In such a case it’s a good idea to let the range continue as an Excel Table but format it manually to choice.Īnother scenario is when you want to keep the exterior of an Excel Table minus the functions of an Excel Table. Although the preset Table styles in Excel are not limited in variety, they may not match some exacting standards. Which is why we would understand if you want to keep the Table for your dataset but not the look of the Table. An Excel Table has easy and impressive features dynamic range, sorting and filtering, a big bunch of selectable styles, a fast track to adding a Total Row are among some.