You can do many things with the name box in excel. In this article, we have discussed complete functionality of the name box. Read to learn more
In Excel, the Name Box refers to an input box to the left of the formula bar – In the picture below as the cell A1 is selected, the column and row are represented in the Name Box.
The Name Box has three main functions inside excel: Selection, Navigation and Naming – See below what can be used inside Selection and Navigation functions.
- Select and Navigate to a specific cell
- Type B5 in the Name Box
- Press Enter
- Select and Navigate to a specific range
- Type B1:B3 in the Name Box
- Press Enter
- Select a Range from the Active Cell
- Select the cell B1 in the Name Box
- Type C10 inside the Name Box
- Press Shift + Enter
- Select a Cell in addition to Active Cell
- Select the cell B1 in the Name Box
- Type C10 inside the Name Box
- Press Ctrl + Enter
- Select multiple Specific Cells
- Type A2 then B5 and C8 separated all by commas in the Name Box
- Press Enter
- Select Entire Column
- Type D:D in the Name Box
- Press Enter
- Select Entire Row
- Type 2:2 in the Name Box
- Press Enter
- Select Specific multiple row
- Type 3:7 and 9:11 separated by commas in the Name Box
- Press Enter
- Select Specific multiple columns & row
- Type B:C and 6:7 separated by commas in the Name Box
- Press Enter
- Select the intersection of Columns & Rows
- Type A:D and 3:8 separated by space in the Name Box
- Press Enter
- Select Entire Worksheet
- Type A:XFD in the Name Box
- Press Enter
- Add additional Ranges to selection
- Select A1:C5 in worksheet
- Type E1:G10 in the Name Box
- Press CTRL + Enter
- Select the entire Column of the Active Cell
- Example: If C4 is selected
- Type C in the Name Box
- Press Enter
- Select the entire Row of the Active Cell
- Example: If C4 is selected
- Type R in the Name Box
- Press Enter
- Collapse Range to Active Cell
- Example: Select any range, in this case will be B2:C3
- Type RC in the Name Box
- Press Enter
Our Friend at How to Excel also has a great article about the name box in excel, check them out to learn more
If you want to learn how to add comments in Excel, you can check out this article to learn more