/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 vote179 views1 answer
Vba horizontalalignment
VBA
2 votes162 views1 answer
Vba split string
VBA
0 vote178 views1 answer
Putting marquee in vb.net
VBA
0 vote181 views1 answer
How to get value from clipboard in vbnet
VBA
2 votes157 views1 answer
Vba array contains
VBA
0 vote173 views1 answer
Excel vba StartUpPosition
VBA
0 vote167 views1 answer
Vba border weight
VBA
0 vote184 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote173 views1 answer
Add text to combobox drop down vb
VBA
0 vote188 views1 answer
Excel vba DisplayAlerts
VBA