/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 vote224 views1 answer
Add control vb
VBA
0 vote220 views1 answer
Excel vba assign shortcut key to button
VBA
4 votes243 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote230 views1 answer
Excel delete ever other vba
VBA
0 vote209 views1 answer
Excel vba show developer tab
VBA
0 vote264 views1 answer
Vbnet add axis labels to chart
VBA
0 vote238 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote239 views1 answer
.net dark title bar
VBA
1 vote224 views1 answer
Vba refresh pivot table
VBA
1 vote233 views1 answer
If inputbox cancel vba
VBA