Microsoft Office Tutorials and References
In Depth Information
Using Keyboard Shortcuts
over the naming process, click the Formulas tab, and then click Define Name from the
Defined Names group. That opens the New Name dialog box, shown in Figure 11-3.
Figure 11-3 Using the Define Name command allows you to add comments to the name you
assign to a cell or range.
By default, all names you create use absolute cell references. For an explanation of this type
of reference, see “Using Formulas and Functions” on page 356.
The rules for a cell or range name are strict: Names are not case-sensitive. The first
character must be a letter, an underscore, or a backslash, and remaining characters (up to a
total of 255) can be letters, numbers, periods, and underscore characters. Spaces,
punctuation, and other special characters are prohibited. You cannot use any name that could
be confused for a cell reference, and you cannot use the single letters C or R (capitals or
To pick from a list of all named cells and ranges in the current workbook, even those on
different worksheets, click the drop-down arrow to the right of the Name box.
Using Keyboard Shortcuts
For the productivity-obsessed, mouse pointers and scroll bars are like roadblocks and speed
bumps. Keyboard shortcuts are almost always faster, and they sometimes offer unique
navigation and tricks that aren’t available any other way. Excel shares a few keyboard shortcuts
with its fellow Office programs, including F2 to make the contents of the current cell
available for editing and F4 to repeat the previous action. Ctrl+X, Ctrl+C, and Ctrl+V work for
Cut, Copy, and Paste; Ctrl+Alt+V for Paste Special; and Ctrl+Z and Ctrl+Y for Undo and
Redo. For formatting, you can count on the old standbys Ctrl+B, Ctrl+I, and Ctrl+U to apply
bold, italic, and underline formatting, respectively, to the current selection.
In Table 11-1, we list some useful and unjustly obscure shortcuts available only in Excel.
Search JabSto ::

Custom Search