The address of the active cell is displayed in

Many students learning EXCEL may ignore the role of the edit bar. The edit bar plays a very convenient role in entering data. If the edit bar is hidden, it will be inconvenient to edit or modify data. Below we will Just learn some knowledge about the edit bar.

1. Get to know where the editing bar is. The red line box checked is the editing bar.

#The name box is used to display the address and name of the current cell. When a cell or range is selected, the corresponding address name will appear in the name box. Use the name box to quickly move to the target cell. For example, enter "B3" in the name box and press the [Enter] key to position the active cell to column B, row 3, as shown in the figure below.

2. Show and hide the edit bar, select "View/Show/Edit Bar, check to show, uncheck to hide".

3. Select the cell and enter the content directly in the edit. Some formulas are long and will be covered by the next cell, but the edit bar can be fully displayed for editing, which is very convenient.

In Excel, the address of the active cell is displayed in the name box on the left side of the edit bar.

4. Display complete data in scientific notation, check whether the current data is a formula, etc.

The formula box is mainly used to enter and modify data or formulas into the active cell. When entering data or formulas into a cell, two buttons will appear between the name box and the formula box. Click the [OK] button to confirm the input or modification of the content of the cell and exit the editing state; click [Cancel] 】 button to cancel editing of the cell, as shown in the figure below.

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of The address of the active cell is displayed in. For more information, please follow other related articles on the PHP Chinese website!