/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 vote163 views1 answer
Vb.net change cursor to wait
VBA
25 votes301 views3 answers
String to date vb
VBA
0 vote158 views1 answer
WGET FTP
VBA
2 votes179 views2 answers
Excel vba if sunday or staurday
VBA
0 vote152 views1 answer
Vba string
VBA
0 vote166 views1 answer
Vba simple quote
VBA
0 vote157 views1 answer
Convert unix to date vba
VBA
0 vote155 views1 answer
Vba array of integers
VBA
0 vote158 views1 answer
Nested if else in vb.net
VBA
0 vote168 views1 answer
Vba paste values
VBA