/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 vote360 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote334 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote365 views1 answer
Return na vba
VBA
0 vote344 views1 answer
Set column width of datagridview vb.net
VBA
0 vote374 views3 answers
Write to text file vb.net
VBA
0 vote352 views2 answers
Vba remove line breaks
VBA
0 vote344 views1 answer
Excel vba current folder
VBA
0 vote356 views1 answer
Delete rows in excel vba code
VBA
0 vote371 views1 answer
Add text to Shape VBA
VBA
0 vote384 views1 answer
Excel vba DisplayAlerts
VBA