Copyright (c) Newday Com. Ltd. All rights reserved-2001-2008


By the end of this lesson, learners should be able to:

  • Specify a print area
  • Preview a page
  • Insert and remove page breaks
  • Print a worksheet or workbook

Specify a print area

In Excel 2003 you can print an entire workbook, a worksheet, a cell range or a cell. Excel defaults to printing the entire worksheet. But if you want to print only a certain area of a spreadsheet then you can define a print area.

To Specify a Print Area:
  • Choose View Page Break Preview from the menu bar.

    View and Page Break Preview Menu Selections
  • A reduced image of the chart is displayed on the screen.
  • Click on one of four blue-colored borders and drag to highlight and select the area to print.

    Print Range
  • Choose File Print Area Set Print Area on the menu bar.

    File and Print Area Menu Selections

Only that area you defined in the print range will print when the worksheet is submitted to the printer for printing.

Preview a page before printing

Excel 2003 provides a Print Preview capability that shows a smaller picture of the printed page directly on the computer screen. Print Preview is a good way for you to review the formatting and make sure the columns, rows and margins appear exactly where you want them.

To Print Preview:
  • Choose File Print Preview on the menu bar, or

    Click the Print Preview button on the standard toolbar.

    File and Print Preview Menu Selections
  • In Print Preview window, the document is sized so the entire page is visible on the screen. Simply check the spreadsheet for overall formatting and layout.

    Print Preview Dialog Box

The Zoom button in Print Preview will enlarge the data so it can be read.

Inserting and Removing a Page Break

There are two different kinds of page breaks in Excel: soft page breaks and hard page breaks. A soft page break is automatically inserted into a spreadsheet when there is too much data to fit on one page. A hard page break is one that you can insert into a spreadhseet, wherever you want it to appear.

To Insert a Page Break:
  • Move the cursor to the row where a page break needs to be inserted. This row will be the first row on the new page.
  • Choose Insert Page Break from the menu bar.

    Insert and Page Break Menu Options
  • A page break, indicated by a dashed line, is inserted into the worksheet.
To Delete a Page Break:
  • Move the cursor to the row where a page break appears
  • Choose Insert Remove Page Break from the menu bar.

    Insert and Remove Page Break Menu Options
  • The page break (represented by a dashed line) is removed from the page.

Printing a Worksheet or Workbook

Printing in Excel is much like printing in other Office applications like Microsoft Word. As previously mentioned, Excel defaults to printing the entire worksheet.

To Print a Worksheet:
  • Choose File Print from the menu bar.

    File and Print Menu Selections
  • The Print dialog box opens.

    Print Dialog Box
  • Specify the Printer Name where the spreadsheet will print. If you only have one printer in your home or office, Excel will default to that printer.
  • In Print Range, choose whether to print All or a certain range of pages (Pages From n to y, where n and y are the beginning and ending page numbers.
  • In Print what, choose whether to print a Selection, the Active sheet or the Entire Workbook (all worksheets in the workbook). Excel defaults to the Active Sheet.
  • Choose the Number of Copies to print by clicking on the up or down arrows.
  • Click the OK button to print the worksheet.

Don't print your Excel spreadsheet without checking spelling first! Excel includes two tools to help correct spelling errors: AutoCorrect and Spelling.



  • Open your Monthly Budget file.
  • Select the 2005 sheet.
  • Use Print Preview to view the sheet and then Print the document.
  • Save and close.


    Congratulations! You have completed all the tutorials and challenges for Excel 2003.
  • Back Next

     Student should make sure to login to class discussion board to view the neccessary information about his or her progress.
     Don,t forget to log out when you are about to leave the class

    Students Should not forget to send his or her registration password and User name to
    For future refrence.
    Student should make sure to subscribe to newsletter of this site for useful information.
     Microsoft Access
     Peachtree Account
     Adobe Photoshop
     Programming
     Café Management
     Repair and Maintenance
     Electronic Basic
     Networking

    => Do you also want a homepage for free? Then click here! <=