Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Lesson 5 - Index Formatting a Page
Section 9 - The Sheet Tab

The Sheet tab is used for customizing the way your spreadsheet will print. There are several options listed under the Sheet tab.

Print Area allows you to specify a certain portion of the spreadsheet to print. If you click on the Collapse Box Collapse Boxnext to Print area: you are able to highlight the area you wish to print.

Print Titles allows you to choose whether or not the column or row titles appear on every page of a multiple page spreadsheet. For example, if you have the namesof sales persons as row labels on a worksheet where the columns of numbers span more than one page on a worksheet, you may want to have the row labels (salespersons' names) appear in column A on every page.

Many options are found under Print. Here you can choose to have the gridlines of your spreadsheet printed, have your spreadsheet printed in black and white and also have it print the column headings.

Page Order allows you to choose which way the spreadsheets will print so that they are easiest to read.

Page Setup: Sheet Tab

Module 5 Lesson 5 Section 8
Module 5 Lesson 5 Section 10

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 08/2007
© 2003, St. Edward's University