/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 vote161 views1 answer
Vba min
VBA
0 vote142 views1 answer
Get current year vb
VBA
0 vote146 views1 answer
Vba pass named range to function
VBA
0 vote116 views1 answer
How to make a if statement with vbs
VBA
0 vote163 views1 answer
For each item in folder outlook vba
VBA
2 votes102 views1 answer
Excel vba pause
VBA
3 votes162 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote148 views1 answer
Vba apostrophe chr
VBA
0 vote144 views1 answer
Vb streamreader
VBA
0 vote140 views1 answer
Vba file size
VBA