RANGES

GGEORGE · Apr 11th, 2002, 11:16 AM

hOW DO I NAME A RANGE AND WHAT IS A RANGE

kinkyparamour · Apr 11th, 2002, 11:31 AM

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 · Apr 11th, 2002, 12:58 PM

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 · Apr 11th, 2002, 01:01 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 11:16 AM	#1
GGEORGE New Member Join Date: Apr 2002 Posts: 1	hOW DO I NAME A RANGE AND WHAT IS A RANGE

Apr 11th, 2002, 11:31 AM	#2
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	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

Apr 11th, 2002, 12:58 PM	#3
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	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

Apr 11th, 2002, 01:01 PM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Another way to name a range is to select it, click on the cell indicator of the formula bar, and type in the name.