/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 vote224 views1 answer
Average vba
VBA
0 vote220 views1 answer
Excel R1C1 mode
VBA
3 votes219 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
2 votes207 views1 answer
Excel vba extract file name
VBA
0 vote227 views2 answers
Get excel file from email attachment in vba
VBA
0 vote205 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote220 views2 answers
Vba string to date
VBA
1 vote232 views2 answers
Get all column names from excel vba
VBA
1 vote215 views1 answer
Excel vba compare 2 rows
VBA
0 vote232 views1 answer
Vba remove the first character of string
VBA