/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 vote80 views1 answer
Vbide vbproject reference
VBA
1 vote116 views1 answer
Vba delete file
VBA
0 vote162 views1 answer
How to call gcd in vba
VBA
2 votes116 views1 answer
Vba uppercase first letter of each word
VBA
0 vote133 views1 answer
Vba clear collection
VBA
0 vote130 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote133 views1 answer
Excel vba DisplayAlerts
VBA
0 vote133 views1 answer
Return na vba
VBA
0 vote142 views1 answer
Vba round to 2 decimals
VBA
1 vote131 views1 answer
Find and replace textbox
VBA