/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

8 votes369 views1 answer
Excel vba make word
VBA
0 vote281 views1 answer
VBA Sleep Snippet
VBA
1 vote274 views1 answer
Vba refresh pivot table
VBA
1 vote268 views1 answer
Excel vba unload userform
VBA
0 vote290 views1 answer
Excel last used row
VBA
0 vote287 views1 answer
Vbscript remove spaces from string
VBA
0 vote264 views1 answer
Vba line feed
VBA
0 vote277 views1 answer
VB get external IP address
VBA
0 vote267 views1 answer
Excel vba automatic calculation
VBA
2 votes259 views2 answers
Constructor vb.net
VBA