/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 vote150 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote147 views1 answer
Set column width of datagridview vb.net
VBA
-1 vote132 views1 answer
Text to speech vb.net
VBA
1 vote172 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote135 views1 answer
Make all controls in an area not visable vb
VBA
0 vote137 views1 answer
Excel vba disable mouse click
VBA
1 vote135 views1 answer
Excel vba saveas force overwrite
VBA
2 votes152 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote148 views1 answer
VBA Sleep Snippet
VBA
0 vote152 views1 answer
Vba listbox remove all items
VBA