/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

5 votes282 views1 answer
Excel vba how to unit test vba code
VBA
0 vote277 views1 answer
Refresh token em vb net
VBA
2 votes287 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote282 views1 answer
Vba remove numbers from string
VBA
15 votes388 views2 answers
Xl vba dynamic string array
VBA
1 vote271 views2 answers
Vba remove first 2 characters from string
VBA
18 votes422 views2 answers
Vba make word from bytes
VBA
0 vote279 views1 answer
Excel vba center userform
VBA
1 vote282 views1 answer
Add a index column power bi
VBA
0 vote297 views1 answer
Vba remove last vbcrlf
VBA