*

Alternatively described as a cell pointer, current cell, or selected cell, one active cell is a rectangle-shaped box the highlights the cell in a spreadsheet. An energetic cell helps identify what cell is being functioned with and also where data will be entered.

You are watching: The contents of the active cell always appear in the


Active cabinet overview

In the picture below the Microsoft Excel, you have the right to see that the energetic cell is D8 and is displayed in the top-left corner.

*


Tip

When you an initial start Excel the energetic cell is the very first cell, i m sorry is always A1. You deserve to move the cell pointer by pressing the arrowhead keys or enter on your keyboard, or you can click any type of cell making use of your computer system mouse. If you"re utilizing the keyboard, friend can likewise press the F2 to modify the active cell.


How is an active cell identified?

An energetic cell or selected cell can be identified numerous ways. First, as presented in the photo above the Microsoft Excel, the active cell has a bold black color box roughly the cell. Also, the column and row are highlighted. In our instance picture, the obelisk header "D" and also row header "8" space highlighted in yellow. The active cell is additionally shown in the top-left section of the window (Name box), i beg your pardon is "D8" in ours example.

Where is the content of the energetic cell is displayed?

The contents of the active cell is shown in the formula bar. In the screenshot above, the formula bar displays the formula in cell D8. The formula, "=SUM(D2:D5)", add to the worths of cells D2 v D5 to compute their complete value, $162.00. As soon as cell D8 is selected, both the cell and also the formula bar display screen the formula. When any other cell is selected, cabinet D8 shows the result of the formula, the full $162.00.

How carry out you change the active cell?

You can adjust the active cell by clicking any other cell with your left mouse button or with the arrow keys top top your key-board to move the selected cell. If the cell contains no data, you can start typing to insert new data into that cell. If the cell already contains data, you deserve to click increase on the formula bar to adjust that data or push the F2 on the keyboard.

See more: Creativity Quiz: How Do You Put An Elephant In A Refrigerator ?: Jokes

Which cell is energetic when Excel is first opened?

When you open a brand-new Excel spreadsheet because that the very first time, the an initial cell is selected by default, i m sorry is A1 (the an initial cell of row A and also column one). If you"ve worked on one Excel spreadsheet in the past, the energetic cell is the last energetic cell position. For example, if you critical left the spreadsheet on cabinet C65, once it is saved and re-opened, it have to return to cell C65.