populating numbers

[sds814]

How would I populate the numbers 1 through 15 (for example) after I highlight rows A1 thru A15?

Thanks.

 

[SkipVought]

Hi,

enter 1 in A1
enter 2 in A2

Select A1:A2 and drag to A15 (or whatever), using the little square in the lower-RH corner of the SELECTION.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[straybullet]

If 1 is in A1, check out Fill Series (Edit menu)...

Let them hate - so long as they fear... Lucius Accius

 

[AnotherHiggins]

-> after I highlight rows A1 thru A15

I don't think it really matters, but to do it after you've already selected the range, you could type in
[tab]=Row()
and press [Ctrl] + [Enter]

Or, along the same lines as Skip's suggestion, enter 1 in A1. Click and drag down to A15 while holding down [Ctrl].

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[sds814]

you guys rock! thanks.