Table of Contents
To add the auto format to your quick access toolbar please follow these steps.
- First of all, go to your quick access toolbar and click on the small down arrow from the endpoint of the toolbar.
home equity loan calculator
- And, when you click on it, you will get a drop-down menu.
- From this menu, click on “More Commands”.
- Once you click on it, it will open “Customize the Quick Access Toolbar” in the excel options.
- From here, click on the “Choose commands from” drop-down and select “Commands Not in the Ribbon”.
- After that, come to the list of commands you have right below this drop-down.
- And, select the “Auto Format” option and add it to the quick access toolbar.
- Click OK.
Now, you have the auto-format icon in your quick access toolbar.
- Select any of the cells from your data.
- Go to the quick access toolbar and click on the auto-format button.
- Now, you have a window, where you have different data formats.
- Select one of them and click OK.
- Once you click OK, it will instantly apply your chosen format to the data.
As I mentioned above, all the formats in the auto format are a combination of 6 different components. And you can also add or remove these components from each format before applying them.
Let’s say, you want to add formatting on the below data table but without changing its font style and column width. You need to apply formatting using the below steps.
- Select your data and click on auto-format button.
- Select a format to apply and click on the “Options” button.
- From options, un-tick “Font” and “Width/Height”.
- And, click OK.
Now, both of the components are not there in your formatting.
Removing Formatting
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.
Important Points
- 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.
Conclusion
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.
