Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

I use custom views, the selection pane, clean UI toggles, and other tools to present my workbook professionally.

Excel comes loaded with lots of tools to help you work smarter and easier. Today we’ll look at three tools — Reports, Views and Outlining — that can make a big impact on your day-to-day work in Excel.

Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.