Microsoft Office Tutorials and References
In Depth Information
Selecting and Deselecting Sheets
To Print All Worksheets in a Workbook
Quick Reference
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
(scsite.com/ex2007/qr).
The following steps print all fi ve sheets in the workbook by selecting all the sheets
before clicking the Print command on the Offi ce Button menu.
1 Ready the printer.
2 Click the Company sheet tab. While holding down the SHIFT key, click the Clustered Cone
Chart tab.
3 Click the Print command on the Offi ce Button menu and then click the OK button in the
Print dialog box to print the workbook as shown in Figure 6–72a and 6-72b.
4 Hold down the SHIFT key and then click the Company sheet tab to deselect all sheets but
the Company sheet.
To Print Nonadjacent Sheets in a Workbook
In some situations, nonadjacent sheets in a workbook may need to be printed. To
select nonadjacent sheets, select the fi rst sheet and then hold down the CTRL key and click
the nonadjacent sheets. The following steps show how to print the nonadjacent Company,
Louisville, and Clustered Cone Chart sheets.
1 With the Company sheet active, hold down the CTRL key, click the Louisville sheet tab, and
then click the Clustered Cone Chart tab.
2 Click the Print command on the Offi ce Button menu and then click the OK button in the
Print dialog box.
3 Hold down the SHIFT key and click the Company sheet tab to deselect the Louisville and
Clustered Cone Chart sheets.
Selecting and Deselecting Sheets
Beginning Excel users sometimes have diffi culty trying to select and deselect sheets.
Table 6–9 summarizes how to select and deselect sheets.
Table 6–9 Summary of How to Select and Deselect Sheets
Task
How to Carry Out the Task
Select adjacent sheets
Select the fi rst sheet by clicking its tab and then hold
down the SHIFT key and click the sheet tab at the other
end of the list of adjacent sheet tabs.
Select nonadjacent sheets
Select the fi rst sheet by clicking its tab and then hold
down the CTRL key and click the sheet tabs of the
remaining sheets you want to select.
Multiple sheets selected and you want to select a
sheet that is selected, but not active (sheet tab name
not in bold)
Click the sheet tab you want to select.
Multiple sheets selected and you want to select the
active sheet (sheet tab name in bold)
Hold down the SHIFT key and then click the sheet tab of
the active sheet.
 
 
Search JabSto ::




Custom Search