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 > Custom Views > Select the view > Click Show
Right click the worksheet tab and choose the view
Go to the View tab and select the view from the Custom Views drop down menu
What is the most efficient way to modify a Custom View?
Add a new view, give it the same name as the existing view, and click Yes when asked if you’d like to delete it and continue
Select the existing view, click the modify button, then save it
Select the existing view, delete it, then create a new one with the same name
What is the best use of Custom Views?
To collapse detail rows and only show subtotals
To build different looks for printing or editing that only show the data you need
To hide data that users should not see when you send them your workbook
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement