/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 vote178 views1 answer
Excel vba disable copy paste
VBA
0 vote198 views1 answer
Find database connection string vb
VBA
0 vote197 views1 answer
Excel vba convert cells address
VBA
0 vote195 views1 answer
Open file dialog in vb.net
VBA
0 vote167 views1 answer
Vbnet add new ecel sheet
VBA
0 vote177 views1 answer
Add items to combobox vb.net
VBA
0 vote184 views1 answer
Excel vba chrw max value
VBA
4 votes136 views2 answers
Vba last row
VBA
0 vote180 views1 answer
Send webhook vbscript
VBA
8 votes267 views1 answer
Vba make integer
VBA