If you’re spending too much time hiding and unhiding rows and columns on your spreadsheet, watch Excel Video 237 to learn about custom views. Custom views are simply a way to save a view of your spreadsheet. You can hide the rows and/or columns you want to and then save as a custom view. When you choose that custom view again, Excel will automatically hide and unhide rows and columns to match your view settings. In our example in the video, it’s easy to switch between all of the detail, the Medicare view, and the Commercial view to only see the rows and columns your end user needs to see.
Watch out for one caveat with custom views. If you have a Table in your spreadsheet, custom views won’t work. As long as you don’t have a table, custom views can save you a bunch of time in a complicated spreadsheet.