How to select all records in a empty column between to filled columns

[boerbende]

Imagine a table. Columns A1..AA100.000. Column B is a calculation column.

I change the calculation in B1, copy it with <CTRL><C>, click on <CLTR><shift><arrow down> and click <CTRL><v>.
This procedure works perfectly when column B has values, but with B empty (so for the first time) these keycombination ends up on the bottom of Excel.
I navigate around this by first clicking <CTL><SHIFT><END> and go back with <SHIFT><Arrow LEFT>, but is there a better way to select all records of B (so that I have all records between B1 and B100.000?

[Domski]

Double right-click in the bottom right hand corner of B1 will autofill the formula down as far as the values in column A go.

Dom

[boerbende]

Double right-click in the bottom right hand corner of B1 will autofill the formula down as far as the values in column A go.

Dom

Great!! Thanks. So simple as that.
Any idea if there are also keyboard options to achieve this?

[Domski]

Ctrl+D but you need to select the range to fill first using Ctrl+Shift+End.

Dom