View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default AutoFill over 30,000 rows

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


"Cathy" wrote:

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...