Sometimes you may need to print two or more reports from the same data on a worksheet. For example, one report may use a different print. Maybe one section you want printed as Portrait and the other you want printed as Landscape.
Often people will resort to printing one section, changing the print settings for the second section, printing the second section, and then changing back the settings for the first section. Fortunately for you, Excel has a Custom Views option that can simplify this process by allowing you to create custom named views that include the print settings for each report. Once you’ve created your Custom View names, you simply select the name for that report and it’s ready to print.
Here’s how it works:
1) Set up the first section of your worksheet the way you want it to look (i.e. selected cells, cells in view, hidden rows/columns, filters, etc…) and print (i.e. Page Layout settings including the Print Area, headers and footers, etc…);
2) Now that you have this section set up as you want it, you will give this a Custom View name. From the View tab, click Custom Views in the Workbook Views group and click the Add… button;
3) You will notice that, in addition to the print settings, you can also choose to include the hidden rows/columns and filter settings. Uncheck the boxes for any settings you don’t want saved with the View.
4) Enter a name for the current View. If you will be creating Custom Views in more than one sheet in the same workbook, it is good practice to include the worksheet name as part of the name for easy future reference;
5) Click OK.
6) Repeat steps 1 to 5 for each Custom View you want to create.
Now whenever you need to print two reports from the same worksheet using different settings, click the View tab and choose Custom Views in the Workbook Views group. Select a view from the list and click Show, then print it. For the second report, select the next View and print it.
Source: Excel addict