Microsoft Office Tutorials and References
In Depth Information
Selecting a Range of Input Cells before Entering Data
Selecting a Range of Input Cells
before Entering Data
Here’s a tip that most Excel users don’t know about: When a range of cells is selected, Excel
automatically moves the cell pointer to the next cell in the range when you press Enter.
The next cell is determined by the Direction setting on the Advanced tab of the Excel Options
dialog box (see Tip 30).
For example, if the Direction setting is Down (or if the Move Selection option isn’t enabled), it
works like this: If the selection consists of multiple rows, Excel moves down the column; when
Excel reaches the end of the selection in the column, it moves to the first selected cell in the
next column. To skip a cell, just press Enter without entering anything. To go backward, press
Shift+Enter. If you prefer to enter the data by rows rather than by columns, press Tab rather