New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Copy 100,000 formulas in 1 second
1 post
• Page 1 of 1
Copy 100,000 formulas in 1 second
by 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! 
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
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
1 post
• Page 1 of 1
Return to Excel Tips and Tutorials
Who is online
Users browsing this forum: No registered users and 1 guest