/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

3 votes146 views1 answer
Vba not equal
VBA
0 vote153 views1 answer
Excel vba saveas no prompt for overwrite
VBA
1 vote153 views1 answer
Excel vba first and last row and column in range
VBA
0 vote152 views1 answer
Vba nested dictionary
VBA
0 vote144 views1 answer
Vba len variant
VBA
1 vote153 views1 answer
Vba date to unix timestamp
VBA
0 vote165 views1 answer
Excel vba open browser
VBA
0 vote155 views1 answer
Vba full date format
VBA
0 vote150 views1 answer
Vba open report
VBA
1 vote163 views1 answer
Add rows to datagridview vb.net
VBA