How to Save Custom Views of an Excel 2013 Worksheet
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.