Naming Cell or Range

Sometime in the work, you create a report read by others (your boss or another colleague who will follow up with you). To simplify the others watch on your worksheet, then the figures obtained from a formula will be more easily understood when read in the formula bar using the names of the cell or range.

For example, the following simple formula will be more elusive readers:

=(04*F4)*(100%-G4)

When compared with the formula below:

(UnitPrice * OrderNumber) * (100%-Discount)

Not to mention the more complicated formula.

Difficulty to understand the meaning of the cell address can be facilitated by naming the cell or range of cells with a name that represents its function, eg D4 cells easier when named the " UnitPrice ", while cell F4 as " OrderNumber ". And so on.

Provisions Name Cell / Range

• The name of the cell / maximum range using 225 pieces of character, but it is recommended to use the shortest possible origin can be understood its meaning. This is because the cell name will be displayed in the formula bar or the Name Box. If it is too long, space available will not fit.
• Writing the cell name should not contain spaces and hyphen (hyphen).
• Name of the cells do not just use numbers only because readers will be interpreted as a constant value.
• Naming cells may use capital letters and ordinary letters.

Here is an example of the cell name is wrong and right.

The wrong name	The correct name
TGL TRANSAKSI	TGL_TRANSAKSI
Account-Book-Big	AccountBigBook
2008	Th2008
%	Persen
A2	Desain_A2

Steps named cell / range:

1. Select the cell or range to be named.
2. Click the Name Range on the Formula tab, Group Named Cells
3. Select Name a range so that the displayed dialog box New Name
4. After typing the name of the cell in the Name box, click OK to close the dialog box.

Choosing a Cell or Range

There are several ways to choose or indicate to a particular cell that is possible when the position was not visible on the screen.

• Typing in the name or address is set in the Name box .


In the Name box, located to the left of the formula bar type the name or address the targeted cells and then press ENTER.


• To type an address in the Name Box Range.

Click the small triangle at the end of the Name box, and then type the address range in the Cell Name box, and then press ENTER.


If there is a cell or range that has been named, then you can call the name of the cell by clicking on the button in the Name Box so that the names of these cells displayed.

To select multiple names at once, after selecting the name of the first press and hold down the Ctrl key and click the next name, and so on.


• Choose a set with a command button Go To.

GO TO commands are shortcut keys Ctrl + G or pressing the F5 function key. After the Go To dialog box appears type the address of the cell that you are headed in the Reference box. Click OK, then the active cell will be at the address you're going.

• Utilizing the Go To Special command to select specific cells.
In the dialog box there is a button GO TO Special, which if you click will display the Go To Special dialog box.

Comment	select the cell containing the comment
Constants	select the cell containing the data constants (typed directly into the cell).
Formulas	selecting the cells containing the formula (there is an option formula number, text, 'logical, and errors).
Blanks	selecting the cells were empty.
Current Region	choose a region, which is a block containing the data without separated by blank rows or columns.
Current array	choose a range of array data.
Objects	select objects that were pasted to the worksheet.
Row differences	to look for differences from the other rows in the range you are looking.
Column differences	to look for differences from other columns in the range that you are looking for.
Precedents	when a formula is selected, then you choose the precedent, then Excel will select the cells are referred to as a reference of that formula.
Dependents	If a cell that contains the data to be referenced from a formula that is typed in a cell to another, so if you choose Dependent, then the active cell will select the cell which utilizes the contents of the cell as a reference formula.
Last cell	selecting cells located in the bottom right corner of the range that includes all of the cells that once you fill the data.
Visible cells only	select all cells except that when it was hidden.
Conditional formats	selecting cells that are defined using the Conditional Format.
Data validation	selecting cells that are formatted using the Data Validation.

Go To Special command in Excel 2007 can also be accessed via the Find & Select button, the Go To Special on the Editing group of the Home tab.