Change the data-entry direction in the current worksheet

The data-entry direction is determined by the data-entry direction arrow in the upper left corner of the worksheet. Click the arrow to change the direction.

Arrow direction Action
When you type a value and press the Enter key, the active cell moves down.
When you type a value and press the Enter key, the active cell moves to the right.
Note

The direction of this arrow also determines how the Home and End keys work.

Change the default data-entry direction for all new worksheets

By default, the data-entry direction is down columns, but you can change it to across rows.

  1. Choose Tools > Options > Data Window > General.
  2. Under Entry direction, choose Enter moves across rows.
  3. Click OK.

Jump to the first cell of the next row or column

The action depends on the data-entry direction:
Arrow direction Action
When you press Ctrl+Enter, the active cell moves to the top of the next column.
When you press Ctrl+Enter, the active cell moves to the beginning of the next row.

Quickly enter data into multiple, adjacent cells

  1. Select the adjacent cells. Adjacent cells can be in the same column or the same row.
  2. Type the value in the first cell and then press the Enter key.
  3. Continue typing values and pressing Enter until all the selected cells are filled.
  4. Press any arrow key to deselect the cells.

Change the width of a column

  1. Move the mouse pointer over the column divider in the top row of the worksheet. This row contains the column IDs.
  2. When the mouse pointer becomes a two-sided arrow, drag the line.
    Column width arrow
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy