/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 vote178 views1 answer
Vba collection key list
VBA
0 vote190 views1 answer
Excel vba join variant array
VBA
6 votes183 views1 answer
Excel vba get the path of current workbook
VBA
18 votes259 views3 answers
Excel-vba make integer
VBA
0 vote174 views1 answer
Open application from vbnet
VBA
2 votes178 views1 answer
Excel vba date to string conversion
VBA
0 vote185 views1 answer
Vbnet click on dgv cells
VBA
0 vote191 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote187 views1 answer
Vbnet hex to binary
VBA
0 vote189 views1 answer
Vb ternary
VBA