Datasheet

12
Part I: Creating Spreadsheets
8. Press Ctrl+P (the shortcut key for printing in Excel).
Excel selects the Print command on the menu in the Backstage View and displays
a Print panel where you can preview the printout (when there’s data in your
worksheet that can be printed) and change simple print settings. Because you
selected the Print panel from an empty worksheet, the message, “Microsoft Excel
did not find anything to print” appears on the right panel where the first page of
the workbook’s print preview normally appears.
9. Press the Escape key to return to the normal worksheet view and then press
Alt+FT.
Doing this selects the Options command in the Backstage View, which in turn,
opens the Excel Options dialog box in the regular worksheet view. This dialog box
contains all the options for changing the Excel program and worksheet options.
These options are divided into categories General through Trust Center.
10. Click the Advanced button in the left pane to display all the Advanced options in
the right pane. Next, scroll down to the Display Options for This Worksheet section
and click the Show Page Breaks check box to remove its check mark before you
click the OK command button to close the dialog box.
Note that deselecting the Show Page Breaks option in the Excel Options dialog box
removes all the dashed page break lines from the Sheet1 worksheet.
Figure 1-2:
The Excel
Backstage
View when
the Info
menu option
is selected.
05_489604-ch01.indd 1205_489604-ch01.indd 12 7/29/10 11:25 PM7/29/10 11:25 PM