Library Home page | Library Catalog
Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Microsoft Office 2010: Page & Print Set Up

Print Set Up

Print with Gridlines
1. Navigate to the Page Layout Tab
2. From the Page Layout Tab, navigate to the Sheet Options grouping
3. Within the Sheet Options grouping under the heading “Gridlines,” select the option for Print (as well as View)

Preview Shortcut

Print Preview
1. A shortcut to view the document in print preview mode is to hold down the CTRL key and press F2
2. Within the Print Preview window, click the icon in red to “Close Print Preview

Managing Worksheets and Workbooks

Renaming Worksheets
1.    To rename a worksheet within a workbook, right-click on the worksheet tab and select Rename from the shortcut menu.
2.    Follow the renaming process for each worksheet
3.    By default, each Excel workbook offers 3 worksheets within each workbook labeled Sheet 1, Sheet 2, Sheet 3

4. After "Rename" is clicked, the worksheet name automatically highlights. Type over the highlighted text to change the name of the worksheet.

Page Setup & Print Preparation

Change Page Orientation
1. Navigate to the Page Layout Tab
2. Expand the Orientation button with the Page Layout Tab’s Page Setup group.
3. Select either Portrait or Landscape

Add a Header and/or Footer to Spreadsheet
1. Navigate to the Page Layout Tab
2. From the Page Layout Tab, expand the Scale to Fit Group so that the Page Setup Dialog Box opens

3. From the Page Setup Dialog box, select the Header tab

4. To create a custom header or footer, select either the Custom Header or Custom Footer button within the dialog box.

5. When the Custom Header or Custom Footer dialog box pops open, select the positions (left, right, center) for your custom text and type.
6. Press OK twice to close out of the dialog boxes