/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

3 votes250 views1 answer
Vba post request json
VBA
0 vote253 views1 answer
Default host vbox address
VBA
0 vote244 views1 answer
Not allow form to be resized
VBA
0 vote226 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote231 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote245 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote258 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote239 views1 answer
Move bindingnavigator vb
VBA
0 vote281 views1 answer
How to enter Vbox manage commands
VBA
5 votes254 views1 answer
Excel vba low word from Long Integer
VBA