Keyboard Shortcut - Highlight to bottom of range based on data one column over

by Alex Keyes   Last Updated September 11, 2019 20:01 PM - source

I work with similar data pulls frequently and am trying to be more efficient in how I transform them.

Typically, I will autofill a field down to the end of the range one column over by using the little black cross displayed when mousing over the active cell:

enter image description here

In this example, I need to fill rows 3 on down by continuing the series in column A. If I use keyboard shortcuts, I can reach the fill (and autofill) dialogue box, but I first have to scroll down to highlight to the bottom of the dates data one column to the right. This can be very tedious in a big data set, because SHFT + DOWN takes me to the bottom of the sheet, not the intended range.

The black cross icon accessed through the mouse understands this logic, but I can't figure out how to reproduce it with shortcuts.

Any thoughts?
It would be super helpful!

Related Questions