Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Checking Spelling, Saving, Previewing, and
Printing the Workbook
Unless you ﬁ rst select
a range of cells or an
object before starting the
spell checker, Excel checks
the selected worksheet,
including all cell values,
cell comments, embedded
charts, text boxes, buttons,
and headers and footers.
With the workbook complete, this section checks spelling, saves, previews, and then prints
the workbook. Each set of steps concludes with saving the workbook to ensure that the
latest changes are saved.
To Check Spelling in Multiple Sheets
By default, the spell checker checks the spelling only in the selected sheets. It will
check all the cells in the selected sheets, unless you select a range of two or more cells.
Before checking the spelling, the following steps select the 3-D Pie Chart sheet so that
the entire workbook is checked for spelling errors.
Printing in Black and
You can speed up the
printing process and
save ink if you print
worksheets with color in
black and white. To print
a worksheet in black and
white on a color printer,
do the following: (1) Click
the Page Setup Dialog
Box Launcher on the Page
Layout tab on the Ribbon,
click the Sheet tab, and
then click ‘Black and white’
in the Print area. (2) Click
the Preview button to
see that Excel has removed
the colored backgrounds,
click the Close button, and
then click the OK button.
You are now ready to
print economically, in
black and white.
1 With the Semiannual Financial Projection sheet active, press CTRL + HOME to select cell A1.
Hold down the CTRL key and then click the 3-D Pie Chart tab.
2 Click the Review tab on the Ribbon and then click the Spelling button on the Ribbon.
3 Correct any errors and then click the OK button when the spell check is complete.
4 Click the Save button on the Quick Access Toolbar.
To Preview and Print the Workbook
After checking the spelling, the next step is to preview and print the sheets. As
with spelling, Excel previews and prints only the selected sheets. In addition, because the
worksheet is too wide to print in portrait orientation, the orientation must be changed to
landscape. The following steps adjust the orientation and scale, preview the workbook,
and then print the workbook.
1 Ready the printer. If both sheets are not selected, hold down the CTRL key and then click
the tab of the inactive sheet.
2 Click the Page Layout tab on the Ribbon and then click the Page Setup Dialog Box
Launcher. Click the Page tab and then click Landscape. Click Fit to in the Scaling area.
3 Click the Print Preview button in the Page Setup dialog box. When the preview of the ﬁ rst
of the selected sheets appears, click the Next Page button at the top of the Print Preview
window to view the next sheet. Click the Previous Page button to redisplay the ﬁ rst sheet.
For a table that lists how
to complete the tasks
covered in this topic
using the mouse, Ribbon,
shortcut menu, and
keyboard, see the Quick
Reference Summary at
the back of this topic, or
visit the Excel 2007 Quick
Reference Web page
4 Click the Print button at the top of the Print Preview window. When Excel displays the
Print dialog box, click the OK button to print the worksheet and chart (Figure 3–72).
5 Right-click the Semiannual Financial Projection tab. Click Ungroup Sheets on the shortcut
menu to deselect the 3-D Pie Chart tab.
6 Click the Save button on the Quick Access Toolbar.