Excel's Custom View settings make it easy to see specific information in a cluttered spreadsheet or 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 where frozen panes or split rows are enabled.
The first thing you'll want to do is create the view that you want to save as a custom view. For example, let's say in some cases you want to be able to hide a series of rows in your custom view. First, create a custom view for when all rows and columns are displayed:
Next, create custom view settings for when specific columns or rows are hidden:
To see the process in action, watch the video below:
To remove a custom view, return to the Custom View dialog, click the view you want to remove, and click the Remove button.
What other scenarios can you use custom views for?
Unfortunately, the Custom View setting doesn't work if you want to toggle different formatting features on font option, highlight, etc.
Are you using Excel's custom views? Have you found any creative uses for the feature? Let us know in the comments.