/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

2 votes235 views1 answer
Excel vba check if string entirely numeric
VBA
1 vote241 views1 answer
Extract the second word in a text in excel
VBA
0 vote304 views1 answer
Vba dictionary clear
VBA
0 vote230 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote233 views1 answer
Loop through all text boxes in a form vb
VBA
5 votes264 views1 answer
Excel vba how to unit test vba code
VBA
0 vote227 views1 answer
Vbs send keys
VBA
0 vote228 views1 answer
Vbs write file
VBA
0 vote230 views1 answer
Rotate image by any angle vb.net
VBA
3 votes234 views1 answer
Vba make long from two words
VBA