Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Clear the Format of a Table in Microsoft Excel

Date:2020-4-3 Author:Cordelia

Sometimes you may not be satisfied with the current format of an Excel sheet and want to reconstruct it from the beginning. Clearing the format at once is the best idea at this point comparing to cancel each operation you’ve done. So how to do it exactly?

1. Drag your mouse to select the whole table, or click any cell in the table and then press [Ctrl+A].

How to Clear the Format of a Table in Microsoft Excel

2. Switch to Home tab and find Editing section on the right.

Click Clear and choose Clear Formats in the drop-down list.

How to Clear the Format of a Table in Microsoft Excel

3. Now the format of this form should be completely removed. You can adjust it again according to your preference.

How to Clear the Format of a Table in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *