/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 vote192 views1 answer
Vba code to open a file with login rights
VBA
0 vote194 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote202 views1 answer
Vba excel do not recalculate before save
VBA
5 votes208 views1 answer
Xl vba double quotes in string literal
VBA
0 vote136 views10 answers
Vba excel create event log
VBA
0 vote213 views1 answer
Excel delete ever other vba
VBA
0 vote203 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote206 views1 answer
Excel vba urlmon
VBA
7 votes201 views1 answer
Excerl vba array to range
VBA
2 votes185 views1 answer
Vba uppercase first letter of each word
VBA