/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 vote317 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote304 views1 answer
Vb.net change cursor to wait
VBA
0 vote312 views1 answer
VB Error Code BC30201
VBA
0 vote321 views1 answer
Afficher un message d'erreur vba
VBA
0 vote300 views1 answer
Vba sheet visible
VBA
0 vote326 views1 answer
Excel vba unlock sheet without password
VBA
0 vote324 views1 answer
Vbs exec hidden
VBA
0 vote297 views1 answer
Vb streamreader
VBA
1 vote278 views1 answer
How to open cmd with vbd
VBA
0 vote288 views1 answer
Excel vba open browser
VBA