Computer Tips

or
"I didn't know you could do that!"

  All Tips:

EXCEL TIP - 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

 

   28-mar-06 11:27 AM

ITS Dept 105 Nicarry Hall
361-1582