/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

-1 vote345 views1 answer
Vba code to add new column in table
VBA
0 vote318 views1 answer
Vba dictionary length
VBA
0 vote360 views1 answer
Excel vba unlock sheet without password
VBA
20 votes479 views1 answer
Excel vba factorial
VBA
4 votes335 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote331 views1 answer
Excel vba move down to next visible cell
VBA
1 vote336 views1 answer
Excel vba force recalculation
VBA
1 vote346 views1 answer
How to remove zeros in excel
VBA
0 vote315 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote330 views1 answer
Vb get ip address
VBA