MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Numbering cells

Posted by Ablation on April 19, 2001 10:27 AM

I cant remember how to have cells format numbers and I just told someone how to do it. For instance, I place a "1" in cell A1 then highlight A1:A10 and hit ???? to have it magically add the numbers in the cells 1-10.
and so forth.

Posted by Aladin Akyurek on April 19, 2001 10:47 AM

Select A1 and A2 (where you have 1 and 2 already entered) and copy down using the fill handle (AutoFill).


Posted by Bj on April 19, 2001 11:14 AM

If you like hot keys...Put 1 in a1, 2 in a2, up arrow twice, hold the shift key and press page
down, then hold down ALT E,I,S, Step value = 1...then hit enter.
Should end up with 1 to 28.

Posted by Mark W. on April 19, 2001 11:23 AM

After selecting cells A1:A10 choose the Edit Fill
Series... menu command and press OK.

Posted by Ian on April 19, 2001 11:53 AM

Just in case the first three ways weren't enough, here is another.
Put 1 in A1
Put the arrow on the fill thingy (technical term) in the lower right corner.
Hit the right mouse button and put down as far as you need to.
Release the right mouse key and select Fill Series

Posted by Bj on April 19, 2001 12:23 PM

After a1=1 and a2=2, go back to a1, then hold the shift key...while holding the shif key
press PageDown. This will select a1:a27. Then hit the ALT key 1 time...then hit 'E'(Edit), then 'I'
(Fill),then 'S'(Series)...Make sure the step value is set to '1' and hit enter...
It will paste 1 - 27 in A1:A27.

Posted by Aladin Akyurek on April 19, 2001 12:38 PM

Got it!

Posted by Bj on April 19, 2001 12:40 PM

Cool beans!