View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
gcanty gcanty is offline
external usenet poster
 
Posts: 4
Default Whats the quickiest way to copy a formula down 13,000 lines in exc

Use Ctrl-C or "Copy" to capture the formula you want to copy,
Use Ctrl-G to go down 13,000 rows,
Use your mouse to click on the last cell in which you wish to copy your
formula,
Hold the Shift Key while you
press and release the End Key and
press and release the Up Arrow Key
Use Ctrl-V or "Paste" to copy the formula in the all of the cells

There may be faster ways but this works for me. Good Luck!

"IMF" wrote:

any help would be appreciated