Microsoft Office Tutorials and References
In Depth Information
Entering and Filling in Data and Series
Press End and then Home to move to the bottom right corner of the portion of the
worksheet that contains data—in other words, the cell that is at the intersection of
the farthest data-containing row and column in the sheet. So, for example, if the
outer reaches of the data in your worksheet (the row farthest from the top and the
column farthest from the left) are in cell A277 and Z1, respectively, this shortcut
takes you immediately to Z277. The keyboard shortcut Ctrl+End leads to the same
Press End and then Enter to move to the last cell in the current row, skipping over
any blank cells. This End Mode trick has no corresponding Ctrl-key shortcut.
End Mode is enabled only until you press another key. If the next key you press is
something other than one of the navigation keys in the previous list, such as a letter or number
or function key, Excel turns End Mode off and processes that key press normally. If you
accidentally enable End Mode, you can turn it off by pressing End again.
Entering and Filling in Data and Series
For basic data entry tasks, Excel works about as you would expect. Click, type, and press
Enter, or use the Clipboard to paste data copied from elsewhere. In this section, we explore
a few techniques that are unique (and useful) in Excel.
When designing a worksheet, you might want to enter a constant value (such as 0) or an
identical formula in a range of cells. Instead of filling each cell manually, speed things up by
selecting the entire range (contiguous or noncontiguous) first. Type the text, value, or
formula you want to include in each cell, and then press Ctrl+Enter. When you use this
technique to enter a formula into multiple cells, the resulting entry uses relative cell references.
If you want one or more references in the formula to use absolute or mixed references,
adjust the formula before you press Ctrl+Enter.
For an explanation of the difference between absolute, relative, and mixed references, see
“Using Formulas and Functions” on page 356.
To enter today’s date into the active cell, press Ctrl+; (semicolon); to enter the current time,
press Ctrl+: (colon).
A handful of keyboard shortcuts and mouse tricks allow you to copy data or formulas or ill
a series through a range. Filling a range is a very powerful way to quickly build a worksheet,
and you can take your pick of menus, keyboard shortcuts, and mouse gestures to
accomplish the task.
Consider this scenario. You have a worksheet in which you have set aside column D for the
results of this month’s sales, which you plan to update daily. You’ve entered a formula in cell
Search JabSto ::

Custom Search