how to clear formatting in excel without clearing contents

How to clear formatting in excel without clearing contents how to#

Just select the columns or rows that contain the data you'd like to remove, and delete, using one of the methods covered in an earlier lesson.

If you also want to remove the formatting, use 'Clear all' in the Clear menu on the home ribbon.Īnother easy way to remove data in a worksheet is to delete entire columns or rows. Notice that deleting cells this way removes the data but not the formatting. Just select the cells you'd like to delete, then press the delete key. Choose 'Clear Contents' to clear just the contents.Ĭhoose 'Clear All' to clear both the contents and the formatting.Ī faster way to clear content is to use the delete key. One way to remove data in Excel is to use the Clear button on the home ribbon. However, you can also remove data by deleting columns, rows, or cells. The most common way to remove data is to use the delete key, or, to use the Clear button on the ribbon. Hopefully, you've found these small tips helpful.In this lesson, we'll look at several ways to delete data in a worksheet.

How to clear formatting in excel without clearing contents how to#

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: 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. To change a table style, just pick any style you want from the gallery.All your original fonts, colors, filling, borders, etc. Simply, convert your data to Excel table, and then perform the above steps to clear the table style formatting. This method comes in handy when you want to get the functionality of a table but keep the existing cell formatting.Both these options remove only predefined formatting included with a table style, but not custom formatting that you've applied manually.Or click the More button in the Table Styles group, and then click Clear underneath the table styles.Īs the result, you will still have a fully functional Excel table but with no formatting:

On the Table Design tab, in the Table Styles group, pick the very first style in Light group, which is called None.

To remove formatting but retain all other features of an Excel table, this is what you need to do:

How to remove Excel table format (convert to range).

Clear all formatting in a table (built-in and custom).

This tutorial will teach you how to quickly do that. In some situations, however, you may want to remove formatting keeping all other functionality of a table. Want to leverage awesome features of an Excel table but do not want any formatting in it? This tutorial will teach you how to quickly clear a table format in Excel.īy default, Excel tables are equipped with many great features including predefined styles.