Table of Contents
Well, to remove formatting from data the best way is to use a shortcut key Alt + H + E + F. But you can also use the auto format option to remove formatting from your data.
- Select your entire data and open auto format.
- Go to last in the format list where you have a “None” format.
- Select it and click OK.
- The auto format is not able to recognize if you already have some formatting on your data. It will ignore and apply new formatting as per the format you have selected.
- You need at least 2 cells to apply formatting with auto-format option.
An auto format is a time- saver tool when you don’t want to put your time and effort into formatting you can use it. It’s quick and simple. It’s all 16 formats are suitable for different types of data, from accounting to list, tables to reports.
I hope it will help you save a lot of time in formatting.