Topics covered include:
Overviewing Excel's Custom Views feature and the types of settings that can be managed in this fashion;
Using Custom Views in Excel 2013 and later to instantly resize the application window for a given workbook;
Using Excel's Custom Views feature to make a single set of data serve multiple purposes;
Turning screen elements such as scroll bars, gridlines, worksheet tabs, and more on or off by way of Custom Views;
Using Excel's Custom Views feature to apply different print settings, including orientation and margins, to a single worksheet;
Freezing or unfreezing worksheet panes on demand with a custom view;
Gaining control of long lists of data by filtering instead of sorting;
Setting a print range that includes multiple noncontiguous areas of a worksheet;
Making the same edits on multiple worksheets at once by grouping worksheets;
Using Custom Views to remember frequently selected cell ranges or cursor positions;
Applying different filter settings with just a couple of mouse clicks using the Custom Views feature;
Protecting hidden sheets from within a workbook.
Upon completing this course, you should be able to:
Define how to replace an existing custom view with new settings;
Identify how to remove all custom views from a given workbook;
Recall how to freeze or unfreeze worksheet panes.
$ 45.00
Course is unavailable for purchase.
NASBA Field of Study
Computer Software & Applications
Level
Intermediate
CPE Credits
2.0
Prerequisites
Experience with Excel Spreadsheets.
Last Updated
10/02/2018
14713
This Site uses cookies to store information on your device. Some are essential to make our Site work properly; others help us improve the visitor and user experience. By using the Site, you consent to the placement of these cookies. Read our privacy policy to learn more.