Question posted 2011 · +129 upvotes
If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows!
Is there a short-cut, similar to ctrl+space, that will apply a formula to the entire column, or to a selected part of the column?
Accepted answer +335 upvotes
Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).
Top excel Q&A (6)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
- Generating CSV file for Excel, how to have a newline inside a value +41 (2009)
excel solutions on this site
— top 1%.