Microsoft Office Tutorials and References
In Depth Information
Multiple Worksheet Basics
Click and the rows or columns will disappear, as will the column letters and/or row numbers of the
hidden items. To hide several rows or columns at the same time, just drag across those columns or drag
down those rows, leave that selection in place, and click the commands you see in 7–4.
Now sooner or later you may want to reveal these clandestine areas of the workbook—and to do
so you need to select rows or columns on either side of the hidden ones. For example, if the K column is
hidden, just drag across any row in the J and L columns (e.g., J23:L23), leave that selection in place, and
click the command sequence as per Figure 7–4—only here you’ll click either Unhide Rows , or in our
ca se Unhide Columns .
Now on to multiple worksheets, because extra space on your single worksheet may not be what
you want.
Multiple Worksheet Basics
As you can see, the three start-off worksheets that stock an Excel workbook share the same first name—
Sheet1, Sheet2, and Sheet3 (you move between worksheets simply by clicking the tab of the sheet you
want to access, or by utilizing these keyboard equivalents: Ctrl+Pg Dn to advance to the next sheet on
the right; Ctrl+Pg Up to the next sheet to your left). But as with file names, Sheet1, etc. are default
identities which can be changed as your needs require. As a result, you might very well want to
rename any or all of these, and it’s easy to do so. To rename a worksheet:
Right-click the tab of the sheet you want to rename. Click Rename on the shortcut
menu (Figure 7–5):
Figure 7–5. By any other name..where to rename a worksheet
Since the current tab is selected, just type the new name, and press Enter.
You can also rename the sheet by double-clicking the sheet tab in question, which also selects the
tab. Type the new name and press Enter. You’re allotted 31 characters per name.
Search JabSto ::

Custom Search