Advertisement
Advertisement


Shortcut to Apply a Formula to an Entire Column in Excel


Question

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 shortcut, similar to CTRL+SPACE, that will apply a formula to the entire column, or to a selected part of the column?

2017/06/14
1
322
6/14/2017 3:57:32 PM

Accepted Answer

Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).

2011/03/24
679
3/24/2011 8:41:02 PM


Select a range of cells (the entire column in this case), type in your formula, and hold down Ctrl while you press Enter. This places the formula in all selected cells.

2012/03/01

Source: https://stackoverflow.com/questions/5425210
Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Email: [email protected]