/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 vote293 views2 answers
Excel vba store array and write to sheet
VBA
0 vote249 views4 answers
Jwt token vb.net validation
VBA
0 vote225 views1 answer
Change form background image vb
VBA
0 vote231 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote218 views1 answer
Vba get text file content
VBA
8 votes244 views1 answer
Excel vba determine number of elements in a 1D array
VBA
1 vote244 views1 answer
Vba login website
VBA
5 votes263 views1 answer
Vba low byte from INTEGER
VBA
1 vote267 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
3 votes274 views1 answer
Vba post request json
VBA