Active Cell

An active cell refers to the currently selected cell in a spreadsheet. It can be identified by a bold (typically blue) outline that surrounds the cell. The standard way to reference the location of an active cell is with a column/row combination, such as A2 (first column, second row) or B5 (second column, fifth row).

Whenever you click on a specific cell within a spreadsheet, it becomes the active cell. Once a cell is selected, you can enter values or a function into the cell. Most spreadsheet programs will display the value of the active cell both inside the cell itself and within a long text field in the spreadsheet toolbar. The text field is helpful for viewing or modifying functions and for editing long text strings that don't fit in the active cell.

Most spreadsheet applications allow you to define a specific data type for individual cells. Therefore, you can use the cell formatting option in the toolbar or select Format → Cells… from the menu bar to choose the data type for the active cell. For example, if the active cell contains the price of an item, you may want to select "Currency" as the data type. You can also format the appearance of an active cell by selecting the font, text color, background color, and text styles.

In most cases, a spreadsheet only has one active cell at a time. However, it is possible to select multiple cells by dragging the cursor over a group of cells. In this case, all of the selected cells may be considered active cells. If you change the cell formatting options while multiple cells are selected, the changes will affect all of the active cells.

NOTE: When writing a function in Microsoft Excel, the ActiveCell property can be used to reference the active cell. The value of the active cell can be accessed using ActiveCell.Value.

Updated February 7, 2012 by Per C.

quizTest Your Knowledge

What is the name of Windows' diagnostic boot mode?

A
Recovery mode
0%
B
Single-user mode
0%
C
Safe mode
0%
D
Maintenance mode
0%
Correct! Incorrect!     View the Safe Mode definition.
More Quizzes →

The Tech Terms Computer Dictionary

The definition of Active Cell on this page is an original definition written by the TechTerms.com team. If you would like to reference this page or cite this definition, please use the green citation links above.

The goal of TechTerms.com is to explain computer terminology in a way that is easy to understand. We strive for simplicity and accuracy with every definition we publish. If you have feedback about this definition or would like to suggest a new technical term, please contact us.

Sign up for the free TechTerms Newsletter

How often would you like to receive an email?

You can unsubscribe or change your frequency setting at any time using the links available in each email.

Questions? Please contact us.