/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 vote249 views1 answer
Vba test optional argument
VBA
5 votes190 views1 answer
Vba array worksheet.index
VBA
0 vote247 views1 answer
Excel vba delete folder
VBA
1 vote283 views1 answer
Perform http request in vb.net
VBA
2 votes242 views1 answer
Vba file from path
VBA
0 vote248 views1 answer
Excel filter by date not working vba
VBA
2 votes237 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote242 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote220 views1 answer
Quit excel with save changes dialog vb.net
VBA
5 votes238 views1 answer
Excel vba tool to help with refactoring code
VBA