If you deal with financial data, then auto format can be one of your best tools. It simply applies the format to small as well as large data sets (especially when data is in tabular form).
- First of all, you need to add it to the quick access toolbar (here are the steps).
- After that, whenever you need to apply the format, just select the data where you want to apply it and click on the AUTO FORMAT button from the quick access toolbar.
- It will show you a window to select the formatting type and after selecting that click OK.
The AUTOFORMAT is a combination of six different formattings and you have the option to disable any of them while applying it.
No comments:
Post a Comment