I have a spreadsheet that is over 15,000 lines long. I need to add a formula in a new column. I can drag that all the way down but I’m hoping there is a way to do it automatically.
Do I need to provide more information?
Create the formula in the first cell, then move the mouse cursor to the bottom right corner of that cell. When it changes to a cross, double-click. Boom. Done!
1 Like
Worked great. Thanks. It even filled exactly to the bottom of the sheet which was more than I expected.
nice description! 
2 Likes