Skip to main content

Active cell of the range

Active cell is a cell in the selected range that the user is currently working with.

You can use the following commands for the active cell:

The formatting properties and number format are displayed for the active cell on the Toolbar.

The visually active cell does not have a translucent color overlay like the other cells in the range, and when there is multiple selection, it is additionally highlighted with a blue frame.

When you select a range, the cell where you started the selection is designated as the active cell.

Examples of active cell placement depending on the direction of selection:

  • The active cell is A1:

cells_active_1

  • The active cell is C1:

cells_active_2

  • The active cell is A3:

  • The active cell is C3:

​

When you use multiple selection, the cell where you started the last range selection is designated as active. In the example below, the range D2:E4 was selected last, and the active cell is D2.

cells_active_multiselect_1

Select the active cell​

If you need to select another cell within the range as active without deselecting the current selection, do the following:

  • Move the pointer to the right or left by pressing Tab or Shift+Tab. The pointer will move along the row.
  • Move the pointer down or up by pressing Enter or Shift+Enter. The pointer will move along the column.
tip

With a multiple selection, the pointer will move between the ranges in the order they were selected. In this case, overlapping ranges do not interfere with each other.