Microsoft Office Tutorials and References
In Depth Information
Don’t Short-Sheet Me!
Likewise, suppose you have another workbook in which you need to get rid of
Sheet2 and Sheet3. Instead of clicking Sheet2, clicking Home ➪ Delete ➪ Delete
Sheet on the Ribbon or pressing Alt+HDS, and then clicking Sheet3 and
repeating the Delete Sheet command, select both worksheets and then zap them out
of existence in one fell swoop by clicking Home ➪ Delete ➪ Delete Sheet on the
Ribbon or pressing Alt+HDS.
To select a bunch of worksheets in a workbook, you have the following choices:
✓ To select a group of neighboring worksheets, click the first sheet tab
and then scroll the sheet tabs until you see the tab of the last worksheet
you want to select. Hold the Shift key while you click the last sheet tab
to select all the tabs in between — the old Shift-click method applied to
✓ To select a group of non-neighboring worksheets, click the first sheet
tab and then hold down the Ctrl key while you click the tabs of the other
sheets you want to select.
✓ To select all the sheets in the workbook, right-click the tab of the
worksheet that you want active and choose Select All Sheets from the
shortcut menu that appears.
Excel shows you worksheets that you select by turning their sheet tabs white
(although only the active sheet’s tab name appears in bold) and displaying
[Group] after the filename of the workbook on the Excel window’s title bar.
To deselect the group of worksheets when you finish your group editing, you
simply click a nonselected (that is, grayed out) worksheet tab. You can also
deselect all the selected worksheets other than the one you want active by
right-clicking the tab of the sheet you want displayed in the workbook window
and then clicking Ungroup Sheets on its shortcut menu.
Don’t Short-Sheet Me!
For some of you, the single worksheet automatically put into each new
workbook that you start is as much as you would ever, ever need (or want) to use.
For others of you, a measly, single blank worksheet might seldom, if ever, be
sufficient for the type of spreadsheets you create (for example, suppose that
your company operates in 10 locations, or you routinely create budgets for
20 different departments or track expenses for 40 account representatives).
Excel 2013 makes it a snap to insert additional worksheets in a workbook (up
to 255 total) — simply click the Insert Worksheet button that appears to the
immediate right of the last sheet tab.