To create a custom view:
- Set the screen up to reflect the look that you want to appear in the custom view.
- Select View | Custom Views.
- Click Add, and in the Name box, enter a name for your view.
- Use the checkboxes in the dialog box to indicate whether you want the view to include the current print settings and settings for hidden rows, columns, and filters.
- Click OK.
Settings that can be included in costum views:
- The active worksheet.Navigate to the sheet you want to be at the front when you open the view and then save the custom view.
- Selected cells. If they're selected (highlighted by dragging the mouse over them) when you set up the custom view, they'll appear selected when the view opens.
- Window position within the Excel window. You can reduce the size of the workbook's window, drag it to a spot in the Excel window, and save that information. This can be useful if you develop preferences for where you like certain pieces of information to hang out on your screen (for example, something such as payroll info on the right and shipping info on the left).
- Hidden rows and columns. Choose Format, Row (or Column), and Hide before saving the view. Here's where you could get fooled about security: Remember that users opening the custom view can unhide the items.
- Print areas. To print only part of a worksheet, select View and Page Break Preview and drag the borders to include the area you want to print. Saving various print areas in different custom views makes quick work of printing things such as sales results from specific regions rather than entire worksheets.