Sunday, September 25, 2011

How to Set Custom Views in Microsoft Excel 2003


1. Set up the page the way you want it to be viewed. Zoom in or out as desired. Determine the page breaks and customize the page as desired.
2. Scroll to the “Views” tab on command bar to access the Views menu.
3. Select “Custom Views” from the drop-down list; a Custom Views properties box will open.
4. Click on the “Add” button to add a custom view. Under the “Name” field, you can name the view you've created. Check the relevant boxes to specify if you wish to include the print settings and any hidden columns, rows and cells in your custom view.
5. Implement the custom view. To add it to your spreadsheet, click the 'OK' button.

Blogger news