/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 vote152 views1 answer
Excel vba move down to next visible cell
VBA
5 votes133 views1 answer
Excel vba high word from Long Integer
VBA
3 votes138 views1 answer
Vba post request json
VBA
2 votes134 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote135 views1 answer
Excel vba hide gridlines
VBA
0 vote135 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote140 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote126 views1 answer
Vba pass named range to function
VBA
0 vote132 views1 answer
Vbscript check if string is empty
VBA
0 vote142 views1 answer
Vbs run with cscript
VBA