/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

0 vote177 views1 answer
Check if cell is dbnullvb.net
VBA
1 vote144 views1 answer
Random number generator vb.net
VBA
0 vote147 views1 answer
Refresh token em vb net
VBA
0 vote158 views1 answer
Vbscript check if string contains
VBA
0 vote154 views1 answer
Return na vba
VBA
2 votes138 views1 answer
Vba split string
VBA
0 vote137 views1 answer
Vba border weight
VBA
0 vote138 views1 answer
Excel vba current folder
VBA
0 vote153 views1 answer
Vba paste values
VBA
7 votes150 views1 answer
Vba array declaration
VBA