10. To name a cell or range over the name box on the macro excel 2003

Fatherly easiest way to name a cell or range is through the name box on the formula bar. The following steps give the stolen name or range of cells via the Name Box:

• To make the name of the cell, place the pointer on the cell which will be named. Point your mouse cursor on the name box, then type the name of the cell that you want. Press the Enter key on the keyboard. C18 cells in the sample name in ga, bar below:

• To create a range name, block range which we will name. Point your mouse cursor to the Name Box, then type the range name you want. Press the Enter key on the keyboard. Name of the range D4: D17 in the example shown below: