HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Use Custom View

Excel 2007: Use Custom View

If you find yourself modifying the display of your worksheet multiple times in the course of working with your spreadsheet, then the Custom Views functionality is definitely for you. Custom Views allows you to save changes to current position and magnification, column widths, row heights, print settings, frozen panes and more. Instead of constantly making these modifications and changing them back, you simply select your custom view and you’re there, switch back to your normal view and you’re back to the default view.


(Do this first) Make a default (normal view) custom view:

1. Make sure that your spreadsheet is in its standard view.

2. Click the View tab and select Custom Views.

3. Click Add.

4. In the Add View dialog box, input a name (like default or normal) and make sure the Print settings and Hidden rows, columns and filter settings checkboxes are checked.

5. Click OK.

6. Save your document.

To create your custom view:

1. Make the changes to the spreadsheet display that you want associated with the custom view.

2. Click the View tab and select Custom Views.

3. Click Add.

4. In the Add View dialog box, input a uniquie Name for your custom view. If you are changing Print settings and/or Hidden rows, columns and filter settings, then make sure these checkboxes are checked.

5. Click OK.

6. Save your document.

To use your custom view:

1. Click the View tab and select Custom Views.

2. Select the desired view and click Show.

To return to the normal view, repeat go back to Custom Views and select the default view that your created.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

4 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android