/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

-1 vote183 views1 answer
Vba sendkeys
VBA
0 vote161 views1 answer
Vba text to general
VBA
0 vote162 views1 answer
Vba add shape oval
VBA
1 vote178 views1 answer
Vbscript convert ascii code to character
VBA
1 vote161 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote173 views1 answer
Internet explorer reference vba
VBA
0 vote189 views1 answer
Tester si une case est vide vba
VBA
0 vote170 views1 answer
Vba add month to date
VBA
0 vote174 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote171 views1 answer
Vba find last column in a row with data
VBA