Sooner or later you will have a worksheet with a number of different sections that would not print well together. What do you do about printing all the parts? it would be time consuming to manually print each section. It would also be time consuming to make a copy of the worksheet and set up different print setups for each sheet.
Or here is another situation. What if you have sections of the worksheet you would like to keep, but not necessarily keep in view. What if there are different rows you want to hide in different parts of the worksheet. It would be time consuming to switch between different views.
Fortunately, Excel allows you to save different views of each worksheet. With custom views you can vary:
The print setup
The views- hidden rows and columns
The exercise is in the Custom Views file. The result is in the Custom Views Result file.
Here is a sheet with two sections we would like to print separately.
This is a simple example, so you could set them up as separate ranges in Print Setup.
But suppose it was more complicated. What if you wanted to hide rows or columns? What if there were many sections so the quick fix for printing shown above would not work?
First, set up the sheet with print setup and the worksheet view you want (what rows display, etc.).
From the Views menu, select Custom Views.
Then click Add.
Then setup your second view. Set up the print setup. Set up the worksheet view. Then repeat the process with Custom Views.
You can then use the View menu, followed by Custom Views, to switch your views.
