New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Copy 100,000 formulas in 1 second

Free Excel Tips and Tutorials

Copy 100,000 formulas in 1 second

Postby Sisyphus » Sat Apr 26, 2014 4:46 am

If you need to copy a formula all the way down your worksheet - 10,000 rows or a million - select the formula to be copied and double-click the drag handle at the lower right corner. Excel will copy the formula down until a blank row is encountered in your table.
Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 2 guests

cron