/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 vote194 views1 answer
Vbnet line graph smooth lines
VBA
0 vote224 views1 answer
Vba table header name
VBA
0 vote214 views1 answer
Label de tableau dans des label.text en VBA
VBA
5 votes227 views1 answer
Excel vba tool to help with refactoring code
VBA
2 votes218 views1 answer
Vba file from path
VBA
0 vote243 views1 answer
Vbnet check if string is only numbers
VBA
27 votes467 views2 answers
Vba check if file exists
VBA
0 vote212 views1 answer
Vb.net change cursor to wait
VBA
1 vote194 views1 answer
VBA Loop through recordset
VBA
1 vote207 views1 answer
How to check is the value enterd is a number or text in vba
VBA