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?
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
Double click the "Collapsed" view, make the desired changes, and then save it
Which is the best reason to use a Custom View over other Excel features?
To hide data you don't want users to see when you send them a workbook
To build different looks for printing or editing that only show the data you need
To collapse details displayed in particular rows and only show subtotals
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement