Excel 2007 - Printing a Portion of a Spreadsheet

- Select the cell range you would like to print
- Under "Page Layout," go to the print area icon; select "Set Print Area"
- Print the worksheet
- Select "Clear Print Area" and the entire worksheet will print next time (instead of just the selected area)

Printing Column Headings on Each Page

- Go to "Page Layout Menu" and click the "Print Titles" icon; then click the "Sheet" tab
- To print column headers on every page, enter the rows containing column labels under "Print titles" under "Rows to repeat"
- Click "Print"

Changing the Default Font

In Excel 2007, the default font and size is Calibri 11.

- Click "Microsoft Office" and then click "Excel Options"
- When creating new workbooks in the "Popular" category:

* click the font you want to use in the "Use this font" box
* enter the font size you'd like to use in the "Font Size" box

NOTE: you must restart Excel to use the new default selection, affecting only newly created workbooks

Excel 2003 - Printing Part of a Spreadsheet

- Select the cell range you'd like to print
- In the file menu, go to "Print Area"
- Then click "Set Print Area"
- Print the worksheet
- When saving, your print area is also saved

Printing Column Headings on Each Page

If you have spreadsheet data spanning several pages and want column headings on each, this will help:

- Click "Page Setup" on file menu, then click the "Sheet" tab
- To print column labels on each page, enter the rows that contain column labels under "Print titles" in the "Rows to repeat at top box"
- Click "Print"

Changing the Default Font

- Click "Options" on the "Tools" menu
- Click a font in the "Standard font" box on the "General" tab
- Click a font size in the "Size" box

NOTE: You must restart Excel to begin using this new default font and font size. This new default will be effective for new workbooks you create - existing workbooks are not affected.

What is the Format Painter?

Those who prefer to do simple Word documents might not be the heaviest Style users. If you'd like to reuse styles you're already created in a document, the Format Painter is an excellent tool. In order to apply a paragraph style from one paragraph to another one:
* put the cursor somewhere in the styled paragraph
* click the Format Painter (Ctrl Shift C)

Click the paragraph where you'd like to apply the style. If you'd like to apply the style to multiple paragraphs, just double-click the Format Painter. Then click in every subsequent paragraph in order to apply this same style.