/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 votes191 views1 answer
Vba low byte from INTEGER
VBA
0 vote172 views1 answer
Visual stuiod not recognising desgined labels
VBA
2 votes178 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
1 vote180 views1 answer
Vb.net get name by Cell Click
VBA
1 vote189 views2 answers
Vba find last row in range for certain criteria
VBA
3 votes170 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote183 views1 answer
Vba array dimensions
VBA
0 vote174 views1 answer
Vba shape transparent
VBA
2 votes168 views1 answer
Excel vba check if key is in collection
VBA
0 vote170 views1 answer
Vba code to open a file with login rights
VBA