Quick Computer Tips

In a little bit of time you can learn a lot

 All Tips:

 

EXCEL 2003 - Custom views make printing and editing easier

Overview:
Different audiences need to see different parts of your spreadsheet. Hiding and un-hiding columns or rows, applying different print settings or filtering a list takes time, especially if you change settings several times a session.

Creating a custom view with the changed settings allows you to quickly select the right "look" for your spreadsheet.

Instruction Sheet (PDF format):
Save Views of an Excel Spreadsheet

Examples:
      Original View

  • All columns and rows show
  • Portrait orientation
  • No rows filtered

      Custom View

  • Columns H, I, J are hidden
  • Landscape orientation
  • Rows filtered to show only employees who work in Canada in Water Rides

5-aug-08 1:41 PM
ITS Helpdesk 108 Nicarry Hall
361-3333