Excel 2007 Printing

Preparing to Print a Workbook

In Excel 2007, you can print an entire workbook or the individual worksheets within the workbook. Preparing to print an Excel 2007 workbook or worksheet can be a complicated process. The information below provides help with the complex formatting sometimes involved in printing a worksheet.

Print Preview

Print Preview shows you what your printed document will look like when printed. Additionally, Print Preview provides access to Page Setup and printing options.

To preview your document using Print Preview, click the Microsoft Office Button and choose Print | Print Preview.

printing_1

 

 

Print Preview displays your worksheet as it will look when printed. When your document opens in Print Preview, a separate Print Preview ribbon displays.



printing_2


The Print Preview tab contains several options for adjusting the way your document will print.

Print

Click Print to print your worksheet as displayed on the screen.

Page Setup

Page Setup provides access to the Page Setup dialog box.

printing_3

The Page Setup dialog box provides access to most of the features needed to print your worksheet to your specifications.

Page tab

Feature Description
Orientation Switch between Portrait and Landscape page orientation.
Scaling Adjust to – Use the Adjust to settings to print the worksheet’s text at a percentage of the original size. For example, choose 100% to print the worksheet data the same size as it is displayed on your screen at 100% zoom.
Fit to – Use Fit to to make the worksheet fit on the desired number of pages. For example, Fit to 1 page tall by 1 page wide will shrink or enlarge the worksheet’s contents until they are displayed on a single page.
Paper size Use the Paper size dropdown to choose the appropriate size.
Paper quality Use the Print quality dropdown to print at a higher or lower resolution.
First page number Use the First page number field to set an appropriate first page number. Leave at Auto for the first page to be counted as 1.
Options Click Options to access the Printer Options for your printer.

Margins

printing_4

Use the Top, Right, Bottom and Left dropdowns to set the appropriate margins.

Use the Header and Footer dropdowns to set the distance from the edge of the sheet for the header and footer to begin.

Use the Center on Page options to center the spreadsheet data horizontally and/or vertically on the printed page.

Click Options to access the Printer Options for your printer.

Header/Footer

printing_5

Feature Description
Header Use the Header dropdown to apply a preset header to your worksheet.
Footer Use the Footer dropdown to apply a preset footer to your worksheet.
Custom Header/Custom Footer Click the Custom Header or Custom Footer buttons to create a custom header or footer for your worksheet.
Different odd and even pages Check the Different odd and even pages checkbox to set different headers and footers for odd and even pages.
First page number Use the First page number field to set an appropriate first page number. Leave at Auto for the first page to be counted as 1.
Different first page Check the Different first page checkbox to set a different first page header or footer. Use this option to “suppress” the first page number.
Scale with document Check the Scale with document checkbox to enlarge/decrease the header and footer with the document.
Align with page margins Check the Align with page margins checkbox to use the same margins in the header and footer as on the page.

Sheet

printing_6

NOTE: Several of the options on the Sheet tab are not available when accessed through Print Preview. For access to all options, click the dialog box launcher in the Page Setup group of the Page Layout tab.

Feature Description
Print Area Click the Print Area button to select and set the print area for the worksheet. This option is not available through Print Preview.
Rows to repeat at top Click the Rows to repeat at top button to select the rows to print at the top of each page. This option is not available through Print Preview.
Columns to repeat at left Click the Columns to repeat at left button to select the columns to print at the left of each page. This option is not available through Print Preview.
Gridlines Check the Gridlines checkbox to print gridlines on the worksheet.
Black and white Check the Black and white checkbox to print the spreadsheet in black and white.
Draft quality Check the Draft quality checkbox to print the spreadsheet at a lower quality and faster speed.
Row and column headings Check the Row and column headings checkbox to print row (1, 2, 3 etc.) and column (A, B, C etc.) on each sheet.
Comments Use the Comments dropdown to choose how comments are displayed in the printed worksheet. This option is not available from Print Preview.
Cell errors as Use the Cell errors as dropdown to choose how cell errors are displayed in the printed worksheet.
Page order Use Page order to choose the appropriate order for printing your worksheet. Choose Down then over for long worksheets. Choose Over then down for wide worksheets.

Page Layout Tab

The Page Layout tab contains many of the functions that are essential to formatting your worksheet for printing.

Themes

Use the options in the Themes group to apply color and font themes to your spreadsheet.

Page Setup

Feature Description
Margins Click the Margins dropdown to select from Excel’s predefined margins or to create your own custom margins.
Orientation Click the Orientation dropdown to switch between Portrait and Landscape orientations.
Size Click the Size dropdown to select the appropriate page size.
Gridlines Check the Gridlines checkbox to print gridlines on the worksheet.
Print Area Click the Print Area dropdown to set or clear the print area.
Draft quality Check the Draft quality checkbox to print the spreadsheet at a lower quality and faster speed.
Breaks Click the Breaks dropdown to insert or remove page breaks.
Background Click the Background button to insert a logo, image or clipart as a background for the spreadsheet. Backgrounds are only visible on screen and will not print.
Print Titles Click Print Titles to access Sheet options including Row and Column headings.
Page Setup Dialog Box Launcher Click the Page Setup dialog box launcher to access all Page Setup options. All Page Setup options are available when accessed this way.

Scale to Fit

Width

  • Select the appropriate width from the dropdown. Automatic is the default and will print to the width of the spreadsheet as displayed at 100% on screen.

Height

  • Select the appropriate height from the dropdown. Automatic is the default and will print to the height of the spreadsheet as displayed at 100% on screen.

Scale

  • Use Scale to scale the worksheet to a percentage of the displayed worksheet.

Dialog Box Launcher

  • Use the dialog box launcher to access the Page Setup options.

Sheet Options

Gridlines
  • View – Check to view on screen.
  • Print – Check to print.
Headings
  • View – Check to view on screen.
  • Print – Check to print.
Arrange
printing_7

Objects can be layered or stacked in Excel. They can be moved backwards or forwards in layers, or can be sent all the way to the back or front of the stack.

Feature Description
Bring to Front Select Bring to Front from the dropdown to move the selected item to the front of the stack. Select Bring Forward from the dropdown to move the selected item forward one layer.
Send to Back Select Send to Back from the dropdown to move the selected item to the back of the stack. Select Send Backward to move the selected item back one layer.
Selection Pane Click Selection Pane to toggle the selection pane. The Selection Pane provides access to all objects in the spreadsheet. All objects can be selected and hidden/viewed from this pane.


printing_8
Align Select the appropriate alignment option from the Align dropdown to align the selected object in the desired way.
Group Select the objects to group and select Group from the Group dropdown. To ungroup, click the grouped objects and select Ungroup from the dropdown.
Rotate Select the object to rotate. Select the appropriate rotation option from the dropdown. The object rotates as desired.

Page Break Preview

Page Break Preview is the easiest way to manipulate how your spreadsheet will print.

To access Page Break Preview, click the Page Break Preview button on the View menu at the bottom right of the Excel screen.

printing_9

Page Break Preiew displays your spreadsheet with dotted blue lines denoting page breaks and sold blue lines noting the edge of the Print Area.

printing_10

To adjust a page break,

  1. Click the page break (dotted line). Notice that your cursor changes to a double ended arrow.


    printing_11
  2. Drag the dotted line to move the page break to the desired location. The page break is moved.

To adjust the Print Area,

  1. Click the print area border (solid line). Notice that your cursor changes to a double ended arrow.


    printing_12
  2. Drag the solid line to the desired location. The Print Area is changed. The Print Area can only be made smaller using this option.

Page Layout View

Page Layout view displays the worksheet on pages showing the header, footer as well as a basic representation of how the spreadsheet will look when printed.

printing_13

Unlike Print Preview, Page Layout view provides access to all Excel features. You can still enter data, use formulas and work in the spreadsheet as you normally would but with access to many of the Page LayoutF options.

Working with Headers and Footers

Headers and Footers can be accessed in two ways in Excel; using the Header/Footer tab of the Page Setup dialog and via the Page Layout view.

Header/Footer Tab

To access the Header/Footer tab, click the Page Setup dialog box launcher in the Page Setup group of the Page Layout tab. Click the Header/Footer tab.

printing_14

Built-in Headers and Footers

To use any of Excel’s pre-defined headers and footers, choose the desired option from the Header and Footer dropdowns.

Custom Headers and Footers

To create a custom header or footer, click the Custom Header or Custom Footer button.

printing_15

The Custom Header or Custom Footer screen opens. In the example below, we will work with the Header screen.

printing_16

Excel divides the header and footer into three sections. Using the options on the Header or Footer screen, we can add any information we would like.

Let’s suppose we want to setup a header that contains a company logo in the left section, the title of the worksheet in the center section and the date in the right section.

First, we’ll work on the left section. To insert a logo into the left section of the header,

  1. Click in the Left section field.


    printing_17


  2. Click the Insert Picture button.


    printing_18


  3. Browse to the location of the logo.


    printing_19


  4. Select the logo and click Insert. The Left section displays Excel’s code for the logo.


    printing_20

    Next we’ll add the title of the worksheet to the center section of the header.

    To add a title to the center section,

  5. Click in the Center section.
  6. Type the title of the worksheet.


    printing_21
  7. Highlight the title and click the Format Text button.


    printing_22


  8. Choose the appropriate formatting options and click OK. The text is formatted.
    Finally, we’ll add the date to the right section.

    To add the date to the right section,

  9. Click in the Right section.
  10. Click the Insert Date button.


    printing_23


    The Right section displays Excel’s code for the date.


    printing_24


    Once the Left, Center and Right components are added, click OK. To view the header, view the document in Print Preview. Headers and footers are not visible in Excel’s Normal view.

How to Link to This Page

It will appear on your page as: GuidesandTutorials.com

 


Search for Tutorials
 

Excel Tutorials: Excel 2007

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

Excel Video Tutorials
Lesson 1: Excel Basics
Lesson 2: Editing a Worksheet
Lesson 3: Making Bar and Circle Graphs
Lesson 4: Making a Gantt Chart
Lesson 5: Excel Keyboard Shortcuts

More Excel Tutorials at GuidesandTutorials.net

All Other Guides and Tutorials

Guides and Tutorials Blog
Listing of the latest tutorials published on the GuidesandTutorials website.
GuidesandTutorials: Audacity Tutorial - Record and Edit Audio
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.
Audacity Tips & Tricks
Audacity tips and tricks submitted by users
Digital Photography Guide
This Digital Photography Guide will provide you with the basic information you need to take professional quality photogrphs with your digital camera.
GuidesandTutorials: Dreamweaver Tutorial
Dreamweaver Tutorial - this series of free Dreamweaver tutorials is just what you need to get up and running with Dreamweaver to create interesting and compelling web sites
GuidesandTutorials: Microsoft Excel 2003 Tutorial
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.
Podcasting Tutorial
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.
PowerPoint Tutorial - Microsoft PowerPoint 2003
This PowerPoint tutorial is just what you need to learn how to use PowerPoint 2003 to create effective and engaging presentations.
The PowerPoint 2007 Window
This PowerPoint 2007 tutorial will show you the features and how to get around the PowerPoint Window.
GuidesandTutorials: Free PowerPoint Templates
Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.
LCD Projector Guide and Tutorial
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.
Word Tutorial: Microsoft Word 2003
This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.
Word 2007 Workspace
This Microsoft Word 2007 Workspace tutorial will acquaint you with the new tools and features in the Word 2007 Window. It's changed significantly from previus versions and even experienced users will find this helpful.
Work at Home Jobs
This Work at Home Jobs tutorial will provide information on ways that you can put your skills and knowledge to use in creating part or full time income while working from home.
Guides and Tutorials: Free Guides and Tutoials Site Map
Free guides and tutorials on podcasting, digital video and audio, Audacity, RSS, multimedia development, educational technology, technology integration, K12 Technology, PowerPoint.
Suggest a New Technology Tutorial
Free Technology Tutorials on software and technology applications including PowerPoint tutorials, Podcasting tutorials, Dreamweaver tutorials, Audacity, Non-Linear PowerPoint, Digital Photography, RSS tutorial, and everything educational technology.
Adobe Acrobat 9 Tutorial
This Adobe Acrobat 9 Tutorial will show you how to create PDFs from MS Office applications, from Multipe files, from web pages and from several other types of documents.
GuidesandTutorials: Free Tutorials
Free Tutorials, software, hardware, and technology applications including PowerPoint, Podcasting, Dreamweaver, Audacity,
Excel 2007 Tutorial | GuidesandTutorials: Free Tutorials
This free Excel 2007 Tutorial will show you how to use all of the begginer and intermediate features in Excel 2007

This site proudly build with Site Build It!

Powered By SiteBuildIt

 

 

Excel 2007 Ebook: The Ultimate Guide - $12.95

Excel 2007 Ebook

Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)

Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.

Excel Video Tutorials
1. Excel Basics
2. Editing a Worksheet
3. Making a Gantt Chart
5. Excel Keyboard Shortcuts

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

More Excel Tutorials at
GuidesandTutorials.net

[?] Subscribe To This Site

XML RSS
follow us in feedly
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines