Locked lesson.
About this lesson
Learn how to create and manage Custom Views in a worksheet.
Exercise files
Download this lesson’s related exercise files.
Custom Views.xlsx15.3 KB Custom Views - Completed.xlsx
15.5 KB
Quick reference
Topic
Custom views.
Description
Creating and managing Custom Views on a worksheet.
Where/when to use the technique
Custom views can be used to build a pre-packaged view of our spreadsheet, including hiding columns or rows. This can be very useful to build different looks to print out or show on screen.
Instructions
Creating Custom Views
- Expand the outlining to level 3
- Go to the View tab --> Custom Views --> +
- Give this View the name of “Full” and click OK
- Collapse the outlining to level 2
- Go to the View tab --> Custom Views --> +
- Give this View the name of “Compressed” and click OK
Using Custom Views
- Go to the View tab --> Custom Views --> Select the view you want --> Click Show
- The view will be activated
Modifying Custom Views
- Show the Compressed view
- Click the – button to collapse line 11 (the Revenues section)
- Go to the View tab --> Custom Views --> +
- Give this View the name of “Compressed” and click OK
- Click Yes when you are asked if you’d like to overwrite the view
Lesson notes are only available for subscribers.