/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 vote244 views1 answer
Label de tableau dans des label.text en VBA
VBA
2 votes224 views1 answer
Date format for ms chart vb.net
VBA
3 votes302 views1 answer
Excel vba make long from two shorts
VBA
0 vote232 views1 answer
Excel vba linter
VBA
0 vote220 views1 answer
Afficher un message d'erreur vba
VBA
0 vote230 views2 answers
Get excel file from email attachment in vba
VBA
0 vote228 views1 answer
Vbs send keys
VBA
0 vote231 views1 answer
Delete rows in excel vba code
VBA
0 vote224 views1 answer
Vba nested dictionary
VBA
5 votes237 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA