Fill all column with value except headline

Occasional Visitor

ola____0-1649681188810.png

I want to fill the column (like CTRL+D) with a value until end except the headline but NOT mark the coulmn (it is 5000 lines long).

1 Reply

@ola___ 

Stay on B3, enter into name box B3:B500, Enter, Ctrl+D