Printing in Excel XP can sometimes be complicated. Learn about Excel XP printing, including setting the right print area, in this lesson.
In Excel XP, you can print an entire workbook, a worksheet, a cell range, or a cell. Excel defaults to printing the entire worksheet. If you want to print only a certain area of a spreadsheet, you can define a print area.
Only the area you defined in the print range will print when the worksheet is submitted to the printer for printing.
Excel XP provides a Print Preview capability that shows a smaller picture of the printed page directly on your screen. Print Preview is a good way for you to review the formatting and make sure the columns, rows, and margins appear exactly as you want them.
The Zoom button in Print Preview will enlarge the data so it can be read.
There are two types of page breaks in Excel: soft page breaks and hard page breaks. A soft page break is automatically inserted into a spreadsheet when there's 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.
Printing in Excel is similar to printing in other Office applications such as Microsoft Word. As previously mentioned, Excel defaults to printing the entire worksheet.
Don't print your Excel spreadsheet without checking spelling first! Excel includes two tools to help correct spelling errors: AutoCorrect and Spelling.