/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

4 votes144 views2 answers
Vba array length
VBA
27 votes271 views2 answers
Vba check if file exists
VBA
20 votes275 views1 answer
Excel vba recursive example factorial function
VBA
0 vote156 views1 answer
If statement vdhl
VBA
0 vote193 views1 answer
Excel vba protect content
VBA
0 vote148 views1 answer
Excel vba convert cells address
VBA
0 vote143 views1 answer
Remove first character from string vb
VBA
0 vote142 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
6 votes154 views1 answer
Excel vba check if a string only contains letters
VBA
1 vote139 views2 answers
Get all column names from excel vba
VBA