|
|
| Charting, Printing and Page Setup |
|
| |
|
|
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.
|
| |
 |
| |
- 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.
|
| |
 |
| |
| Choose File Print Area Set Print Area on the menu bar. |
| |
 |
| |
| 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 |
| |
 |
| |
| 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. |
| |
 |
| |
 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.
|
| |
 |
| |
- 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.
|
| |
 |
| |
- 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.
|
| |
 |
| |
| The Print dialog box opens. |
| |
 |
| |
- 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. |
| |
| Look Up! |
| |
- Open your Monthly Budget file.
- Select the 2005 sheet.
- Use Print Preview to view the sheet and then Print the document.
- Save and close.
|
| |
| |
