/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 vote126 views1 answer
VBA Sleep Snippet
VBA
0 vote151 views1 answer
Winforms dark title bar
VBA
11 votes247 views1 answer
Excel vba How to URL encode a string
VBA
1 vote123 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote117 views1 answer
Vba DisplayGridlines
VBA
1 vote111 views1 answer
Excel vba to lower case
VBA
1 vote136 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote138 views1 answer
Excel vba round to whole number
VBA
0 vote125 views1 answer
Excel vba urlmon
VBA
0 vote120 views1 answer
Excel vba chrw max value
VBA