Introducing Custom Views

Custom Views captures and applies visual aspects of Excel workbooks and worksheets. To be clear, Custom Views does not change the contents of worksheets cells. In that regard, I discussed Excel’s Scenario Manager feature in Chapter 6, What-If Analysis, which does enable you to swap out different sets of inputs. Custom Views enables you to manage the following aspects of an Excel workbook:

• Worksheet and feature settings:
  • Hidden or visible status of worksheets
  • Hidden or visible status of rows and columns
  • Freeze panes settings
  • Cell selection and cursor positioning
  • Filter Buttons and settings
  • Page Setup settings, including print ranges and page orientation
  • Displaying page breaks
  • Displaying worksheet columns from right to left (instead of left to right)
• Visual settings:
  • Display modes, including Normal, Page Break Preview, and Page Layout
  • Window sizes and positions
  • Worksheet zoom settings
  • Row and column headings
  • Displaying formulas instead of calculated results...