/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 vote172 views1 answer
Vlookup columns not next to each other
VBA
0 vote178 views1 answer
Vba type
VBA
4 votes183 views2 answers
Excel vba last column with data
VBA
0 vote180 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote168 views1 answer
Vba first cell in range
VBA
1 vote192 views1 answer
Vba optional
VBA
0 vote183 views1 answer
Create links in msgbox in vb
VBA
0 vote197 views1 answer
Vba search string position
VBA
0 vote177 views1 answer
Vba run command
VBA
1 vote184 views1 answer
Excel vba last row of range
VBA