Tips For Often-Used Applications

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.

Excel 2007

Printing Part of a Spreadsheet

Select the cell range you'd like to print

Under "Page Layout," go to the print area icon and select "Set Print Area"

Print the worksheet

Select "Clear Print Area" and the whole 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

What's 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.