tahirih
asked on
Excel - Copy Formulas in multiple columns
Hi,
In a spreadsheet, I have formulas in Columns A - Q in row 1. I want to copy each of the columns formulas down to row 200000 in Excel 2007.
Currently, I can only do this one column at a time, but going to the cell locator box, typing A1:A200000, Ctrl D, and Enter.
Is there a way to achieve this for all columns at once?
Thank you
In a spreadsheet, I have formulas in Columns A - Q in row 1. I want to copy each of the columns formulas down to row 200000 in Excel 2007.
Currently, I can only do this one column at a time, but going to the cell locator box, typing A1:A200000, Ctrl D, and Enter.
Is there a way to achieve this for all columns at once?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER