How to Save Custom Views of an Excel 2013 Worksheet
Make all the necessary changes to the worksheet display so that the worksheet window appears exactly as you want it to appear each time you select the view.
Also select all the print settings on the Page Layout tab that you want used in printing the view.
Click the Custom Views command button in the Workbook Views group at the beginning of the View tab or press Alt+WC.
This action opens the Custom Views dialog box, where you add the view that you’ve just set up in the worksheet.
Click the Add button.
This action opens the Add View dialog box, where you type a name for your new view.
Enter a unique descriptive name for your view in the Name text box.
Make sure that the name you give the view reflects all its pertinent settings.
To include print settings and hidden columns and rows in your view, leave the Print Settings and Hidden Rows, Columns and Filter Settings check boxes selected when you click the OK button.
If you don’t want to include these settings, clear the check mark from either one or both of these check boxes before you click OK.
When you click OK, Excel closes the Custom Views dialog box. When you next open this dialog box, the name of your new view appears in the Views list box.
Click the Close button to close the Custom Views dialog box.
Custom views are saved as part of the workbook file. To be able to use them whenever you open the spreadsheet for editing, you need to save the workbook with the new view.
Click the Save button on the Quick Access toolbar or press Ctrl+S to save the new view as part of the workbook file.
After you create your views, you can display the worksheet in that view at any time while working with the spreadsheet.