0
A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.
What else can I help you with?
Where do you type a cell reference and then move directly to that cell in Excel?
The Name Box. If you type in a cell reference in the Name Box, and press Enter, it will bring you to that cell. You can also press F5 to open the Goto dialog box and use that to go to a particular cell too.
What is the difference of name box to cell reference?
A name box is on the spreadsheet, beside the formula bar and it shows the cell reference or a range name. A cell reference refers to a cell, by its column letter(s) and row number.
What does Name Box show?
name of cell or cell reference
The box displays the active cell reference?
The Name box.
Where in Excel do you type a cell reference and then move directly to that cell?
In the Name Box or by starting the Goto facility by pressing the F5 key and typing into the reference box.
what is Box where cell reference of the active cell is displayed?
Name box Want to earn money by creating a website check my profile !!!
Does the name box display entries as they are made and edited in the workbook window?
The name box displays the name or cell reference of the active cell.
Do the contents of the active cell display in the name box?
yes
What happen whaen you key a cell reference in the name box and strike enter?
It will move the cursor to the cell you specify.
As you type Excel displays the entry in the and also displays the active cell reference in the name box on the left?
As you type, Excel displays the entry in the FORMULA BAR, and also displays the active cell reference int he Name box on the left.
What name does the name box display?
It will display either the current cell or a name of a named range if that range is selected. If the range selected is not named, then the name box show the cell reference of the active cell.
What is the cell reference area located below the ribbon?
The cell reference area below the ribbon is called the Name Box in Excel. It displays the address or name of the currently selected cell in the worksheet. It can also be used to navigate to specific cells by typing in the cell reference directly.
