Back to lesson
1. How do you activate a Custom View in Excel?
Go to the View tab and select the view from the Custom Views drop-down menu.
Go to the View tab and Custom Views, and then select the view and Click Show.
Right click the worksheet tab and choose the view.
2. Which is the most efficient method to modify a Custom View?
Select the existing view, delete it, and then create a new view with the same name.
Select the existing view, click the modify button, and then save it.
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.
3. Which use of Custom Views is best?
To hide data you don't want users to see when you send them a workbook.
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.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement