Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Inside Excel 2010
To rename a worksheet, double-click its name on the sheet tab and begin typing. A sheet
name can have a maximum of 31 characters and can include spaces, parentheses, and most
punctuation marks, with the exception of the following prohibited characters: [ ] / \ ? * :
(brackets, slash and backslash, question mark, asterisk, and colon).
Just because you can create a 31-character sheet name doesn’t mean you should. The
names of worksheets are used in formulas when a referenced cell location is on a sheet
other than the one containing the formula. Short, simple, descriptive names work best
for this purpose; long, complex sheet names make it difficult to understand the design
of a workbook or to debug a formula.
To color-code a worksheet tab (or a group of tabs selected using the standard Ctrl+click
method), right-click the selected tab and click Tab Colors. You can choose any standard
color or a color from the current theme. Colored tabs are best used sparingly to help
visually identify a group of related tabs or to make it easier to spot summary sheets.
To move a worksheet within a workbook, drag the sheet tab left or right. When the black
triangular marker is over the location where you want the sheet to appear, release the
mouse button. To move a sheet to a different workbook, make sure the destination
workbook is open; then right-click the tab you want to move, and click Move Or Copy. In the
Move Or Copy dialog box, select the name of the destination workbook from the To Book
drop-down list and the tab location from the Before Sheet list, and then click OK.
To copy a worksheet to the same workbook, hold down the Ctrl key and drag the sheet tab
left or right. The contents of the copied sheet are identical to the original, and the name
is the same except for a numeric suffix. To copy a sheet to another open workbook, follow
the same steps as for moving the sheet, but select Create A Copy from the Move Or Copy
dialog box before clicking OK.
To hide a worksheet, right-click its tab and select Hide from the shortcut menu. The
contents of that sheet are still available for formulas, but they are unavailable for casual
inspection. This isn’t a security feature—its primary purpose is to remove potentially distracting
elements that are necessary for workbook calculations but shouldn’t be changed. To see a
list of hidden sheets so you can make one or more visible, right-click any sheet tab and click