/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 vote180 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote176 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
20 votes341 views1 answer
Excel vba factorial
VBA
-1 vote193 views1 answer
Code for reading letters only in vb 6
VBA
0 vote169 views1 answer
Vba shape transparent
VBA
3 votes188 views2 answers
Vba active workbook path
VBA
0 vote230 views2 answers
VB
VBA
22 votes314 views1 answer
Excel vba check if directory exists
VBA
-1 vote173 views1 answer
Vba sendkeys
VBA
0 vote128 views1 answer
Vbide vbproject reference
VBA