2014/02/24
Ever spend time setting up a spreadsheet view exactly the way you want it and then have to redo it again later? If so, then Excel Custom Views are for you. Customize your view in an Excel workbook and it will be available in that workbook for use anytime.
This tip will show you how to use CUSTOM VIEWS to save your frequently used print options, hidden column or filter settings. We'll even show you how to add a drop-down list for Custom Views to your Quick Access Toolbar.
SAVE A DEFAULT CUSTOM VIEW
In order to get back to an unformatted version of your workbook, you should first create a default view following the steps below.
On the VIEW tab, click the CUSTOM VIEWS button.
The Custom Views dialog opens.
Click the ADD. . . button.
The Add View dialog opens.
Enter the name View_All for the View.
Use the check boxes to select which settings to include in the view.
Click OK.
SAVE A CUSTOM VIEW
After creating a default custom view, set the spreadsheet options that you wish to save. This can include print settings, page layout options like headers/footers, hiding rows or columns, or filtering - any number of options. After setting the options within the spreadsheet, follow the steps above to create a custom view of your workbook. Enter a name that will quickly identify the settings being applied.
SHOW A CUSTOM VIEW
On the VIEW tab, click the CUSTOM VIEWS button.
The Custom Views dialog opens.
Select the view you want to see.
Click the SHOW button.
ADD CUSTOM VIEWS TO THE QAT
If you're going to use Custom Views frequently, as a timesaver, you may wish to add them as a drop-down menu on your Quick Access Toolbar.
- Click the drop-down arrow at the end of the Quick Access Toolbar and select MORE COMMANDS. . .
Your Quick Access Toolbar is located either directly above or below the ribbon.
- From the Choose commands from: drop-down menu, select COMMANDS NOT IN THE RIBBON.
- From the list of commands, highlight CUSTOM VIEWS.
- Click the ADD button.
- Click the OK button.
The Custom Views drop-down list is added to your Quick Access Toolbar.
Submitted by: Michelle Spencer, Senior Trainer