/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 vote213 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote210 views1 answer
Excel vba first working day month
VBA
5 votes211 views1 answer
Excel vba right word from Long Integer
VBA
0 vote266 views1 answer
Vba vbcrlf chr
VBA
-1 vote214 views1 answer
VBA check if a cell contains a letter or string
VBA
8 votes201 views1 answer
Excel vba make a short integer from two bytes
VBA
2 votes192 views1 answer
Excel vba extract file name
VBA
0 vote226 views1 answer
Vba open report
VBA
0 vote208 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote201 views1 answer
Excel vba address not absolute
VBA