AutoFill over 30,000 rows

[Guest]

Is there a shortcut way to autofill several thousand rows? I have a simple
numeric autofill that I have to hold down for quite a while (okay, so my
machine is slow... it's corporate equipment, there's nothing I can do about
it...). Is there some quick fix like hold down shift+the ending row
number+bang on the escape key three times... you know... some trick?

Thanks for any help you can provide,
Still waiting on Excel...

 

[daddylonglegs]

If you have data in an adjacent column, e.g. you want to autofill colum
B and you already have data in A1:A30000 (without blanks) you can jus
double click the "fill handle" (thats the black + that appears when yo
put the cursor on the bottom right corner of the cell) and it shoul
fill down automaticall

 

[Guest]

Without knowing the specifics of your numbering scheme, I can only try to
point you in the right direction.

Try selecting the first cell of your range. Enter the starting value there.
Select "Edit" then "Fill" then "Series..."

Select Column, and enter your increment value and your ending value.

HTH,
Elkar

 

[Guest]

Thank you so much! This is exactly what I needed

 

[mickbarry]

Nice one Daddylonglegs,
For years I have been doing the following-
"left arrow" (Go to top of adjoining data)
"Control down arrow" (Go to bottom of adjoining data)
"right arrow"
type a character (Type a placemark)
"Control shift up arrow" (Go to original formula)
"Control shift down arrow" (Highlight area where formula is to b
copied to)
"Control D" (copy down)

Reckon that you have saved a few extra days of my developing life

Regards Mick Barry
Why isn’t there mouse-flavoured cat food