Page 64 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 47
Chapter 3: Printing Spreadsheet Reports 47

To help you identify the cell reference of each formula in your printout, be sure to
include the gridlines and column and row headings as part of the printout.

Try It

Exercise 3-9: Printing the Formulas in a Spreadsheet
Open the Exercise3-9.xls workbook in the Chapter 3 folder in your My Practice
Spreadsheets folder in My Documents on your hard disk (or in the Excel Workbook
folder on the workbook CD-ROM). Use this copy of the Income Analysis spreadsheet to
practice printing the formulas in a table of data in a workbook:

1. Display the formulas in the cells of the Income Analysis spreadsheet by selecting
the Formulas check box on the View tab of the Options dialog box (Tools➪
Options). Note how turning on the formula display enlarges the columns to
accommodate all the formulas.
2. Press Ctrl+~ (tilde) to turn off the formula display and return to the normal work-
sheet display.
The tilde key is located on the ` key (accent grave) that is usually located to the
immediate left of the 1 key on the top row of the QWERTY keyboard.
Ctrl+~ (tilde) is a toggle key combination: The first time you press it, it turns on
the formula display and the second time turns it off.
3. Press Ctrl+~ (tilde) again, this time to turn the formula display back on and then
change the following settings in the Page Setup dialog box:
• Change the orientation of the printing from portrait to landscape.
• Add a centered header that contains the text Formula Check and a cen-
tered footer that displays the current page number and total pages in the
report, both in 10-point Arial Black.
• Make the row 3 the Rows to Repeat at Top and column A the Columns to
Repeat at Left.
• Add the gridlines and the row and column headings to the printout.
• Change the page order from Down, Then Over to Over, Then Down.

4. Close the Page Setup dialog box and then display the Income Analysis worksheet
in the Print Preview window. Note that the report now contains 18 pages.
5. Constrain the pages to 9 pages wide by 1 page tall and center the data on each
page horizontally between the left and right margins; then close the Page Setup
dialog box and return to the Print Preview window.
6. Turn on Page Break Preview mode and then dispense with the Welcome dialog box.
7. Move the page markers so that page 1 contains only Qtr1 figures; page 2 only
Qtr2 figures; page 3 only Qtr3 figures, and page 4, the Qtr4 figures with the grand
totals.
8. If you have access to a printer, click the Print button on the Standard toolbar to
print the four-page report showing all the Income Analysis formulas; otherwise,
use Print Preview to verify the layout and contents of these pages and then
return to the Normal worksheet mode.
9. Hide the display of the formulas in the cells.
10. Save the workbook as Solved3-9.xls in the Chapter 3 folder in your My Practice
Spreadsheets folder and then close the workbook file.