Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
How do you activate a Custom View in Excel?
Go to the View tab and Custom Views, and then select the view and Click Show
Go to the View tab and select the view from the Custom Views drop-down menu
Right click the worksheet tab and choose the view
What is the most efficient way to update the "Collapsed" Custom View shown in the list below?
Double click the "Collapsed" view, make the desired changes, and then save it
Add a new view, give it the name "Collapsed", and click Yes when asked if you’d like to delete it and continue
Select the existing "Collapsed" view, delete it, and then create a new view with the same name
Which is the best reason to use a Custom View over other Excel features?
To collapse details displayed in particular rows and only show subtotals
To build different looks for printing or editing that only show the data you need
To hide data you don't want users to see when you send them a workbook