/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

1 vote231 views1 answer
How to remove zeros in excel
VBA
0 vote272 views1 answer
Visual basic cmd
VBA
3 votes222 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote228 views1 answer
Worksheet.pastespecial textbox
VBA
1 vote222 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote235 views1 answer
Tester si une case est vide vba
VBA
1 vote213 views1 answer
Close form vba
VBA
0 vote260 views1 answer
Vbnet add axis labels to chart
VBA
0 vote236 views1 answer
Return na vba
VBA
3 votes269 views1 answer
Excel vba make long from two shorts
VBA