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
|