/VBA/Shortcut to apply a formula to an entire column in excel

Shortcut to apply a formula to an entire column in excel

Select the top cell and double-click the drag square (bottom-right).

This copies the top cell all the way down until the data end.

Another thing: you can select a large range and type the formula
in the Formula Bar and confirm with Ctrl-Enter.

Source: academy.excelhero.com

Similar codes

2 votes292 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
25 votes392 views2 answers
Excel vba folder exist
VBA
1 vote286 views1 answer
Excel vba get ordinal number from cardinal number
VBA
8 votes394 views1 answer
Excel vba make word
VBA
22 votes413 views1 answer
Xlvba check for folder
VBA
0 vote290 views1 answer
Excel protect cells with formulas
VBA
0 vote286 views1 answer
Compare dates vb
VBA
1 vote282 views1 answer
If inputbox cancel vba
VBA
15 votes394 views2 answers
Xl vba dynamic string array
VBA
0 vote286 views1 answer
Vba timestamp -- milliseconds
VBA