View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dennis1188 Dennis1188 is offline
external usenet poster
 
Posts: 27
Default Copy same cell formula in many rows...

I would like to copy a cell formula by left clicking the bottom right corner
, hold and drag down 2000 rows.

Excel quickly counts past 2000 rows and I go up and down till I get it right.
Is there a way to left click, hold and maybe enter the row number??