Hi,
Sorry to be a newb here but I have a tiresome problem
I have spreadsheets of data that are multi-column and about 100,000 rows each. I need to copy a formula (=sum(A1/B1)*C1 for example) in cell D1 into the 100,000 cells below D1 in column D. I can copy D1 and then highlight D2 and drag into the cells below but this takes a LONG time for 100,000 rows.
Is there an easier way? Thanks for your help.
Bookmarks