RANGES

[GGEORGE]

hOW DO I NAME A RANGE AND WHAT IS A RANGE

 

[kinkyparamour]

A range is a collection of cells, for example A1:a10 is a range. To name your range goto insert/name/define. In the popup window on the top line place a name, example Totals, on the bottom line where it says refer to put the cell range. In this case A1:a10....That's all there is to it.


Denny

 

[kinkyparamour]

A range is a collection of cells, for example A1:a10 is a range. To name your range goto insert/name/define. In the popup window on the top line place a name, example Totals, on the bottom line where it says refer to put the cell range. In this case A1:a10....That's all there is to it.


Denny

 

[Steve Hartman]

Another way to name a range is to select it, click on the cell indicator of the formula bar, and type in the name.