/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 vote416 views2 answers
Excel vba store array and write to sheet
VBA
8 votes394 views1 answer
Excel vba make integer
VBA
1 vote336 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote492 views1 answer
Amd64 vs arm64 linux
VBA
0 vote343 views1 answer
Weekday vba
VBA
22 votes553 views1 answer
Excelvba check for directory
VBA
0 vote351 views1 answer
Return na vba
VBA
0 vote335 views1 answer
Excel vba cell on change
VBA
0 vote315 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote344 views1 answer
VBA Sleep Snippet
VBA