How to Use the Name Box in Excel

MakeUseOf | 7/18/2019 | Saikat Basu
n.king (Posted by) Level 3
Click For Photo:

You can’t go anywhere in Microsoft Excel without using this humble little box. But where is the Name Box in Excel? It lies right next to the formula bar in a worksheet and displays the address of the selected cell or an object. But that’s just the most obvious use. You can navigate around the sheet with it or use it as a powerful selection tool.

But that’s just the scratching the corners of the box. Let’s look at all the productivity purposes the Name Box was created for.

Screen - Name - Box - C4 - Cell

As shown in the screen above, the Name Box shows C4 because the cell C4 is selected right now. Click on any cell to get the cell address to use in a formula.

The Name box won’t just give you the address of one cell. It can be applied to any group of cells too. For instance:

Block - Cells - Name - Box - Cell

Select a block of cells. The Name Box will identify the first cell in the selected group of cells.

Select a range of non-contiguous cells. You can select several cells that are not grouped together. Press the Ctrl key and choose a bunch of non-contiguous cells. The Name Box in Excel will display the address of the last cell you select.

Way - Cell - Range - Cells - Address

You can go the other way also. If you want to go to a specific cell or a range of cells, then you can type the address of that cell in this Name Box and select them in a pinch.

Let’s see how it can speed up your work when you have a lot of rows, columns, and even sheets to work with.

Mouse - Block - Cells - Addresses

Let’s do away with the mouse to select a block of cells with their addresses alone.

Select a block of cells. In the screenshot below, I typed A2:B10 in the Name Box and then pressed Enter. This selects a...
(Excerpt) Read more at: MakeUseOf
Wake Up To Breaking News!
Sign In or Register to comment.

Welcome to Long Room!

Where The World Finds Its News!