Use Custom Views in Excel to Save Specific Worksheet Layouts
Excel’s Custom View setting makes it easy to view specific information on a crowded spreadsheet or to create different layouts for your data. You can use it to create custom headers or footers, create a print-friendly version of your spreadsheet, or you can create a view in which freeze panes or split rows are activated. The first thing you’ll want to do is to create the view you want to save as a custom view. For example, let’s say you want in some instances to be able to hide a series of rows in your custom view. First, create a custom view…
Read the full article: Use Custom Views in Excel to Save Specific Worksheet Layouts