Fill Down Quickly in Excel 2010 with Huge Number of Records

Trying to Quickly Fill Down a formula in a field a 2010 Excel file with 100,000 records.  Dragging is too slow.  Searched online and the EE knowledgebase with no luck.  Any suggestions?
LVL 2
rvfowler2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
aikimarkConnect With a Mentor Commented:
Ctrl+Shift+downarrow
Ctrl+D
0
 
NBVCConnect With a Mentor Commented:
Is it a formula next to another column?  You can double-click the little black square at bottom right corner.  This will copy down until it finds blank cell in adjacent column.
0
 
rvfowler2Author Commented:
The first one worked fine.  The second solution worked in one test, but in another test, it froze up my Excel and my PC, so I think the first one is safe.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.