<div>
The first one worked fine. &nbsp;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. &nbsp;Thanks.
</div>


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.

<div>
<div class="content wysiwyg-content">
Trying to Quickly Fill Down a formula in a field a 2010 Excel file with 100,000 records. &nbsp;Dragging is too slow. &nbsp;Searched online and the EE knowledgebase with no luck. &nbsp;Any suggestions?
</div>
</div>


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?

Fill Down Quickly in Excel 2010 with Huge Number of Records

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.