Could not find an answer to this through about 30+ minutes of Google searches, thought I would check here.

I work with a lot of Excel spreadsheets, and I try to avoid using my mouse as I work quicker with the keyboard commands. One issue that has persisted is the use of autofill. Example follows:



In the above, I want to fill my formula from cell B2 into the cells below it (B3:B11) without using my mouse. I can select the cells below by holding shift and then fill using Ctrl + D, but this is not feasible when working with thousands of rows. I cannot use Ctrl + Shift + Down as this would bring me to the bottom of Excel (row 1000000+), and I only want to fill up to B11. I cannot use Ctrl + Shift + End as this selects up to C11, and again, when working with a larger data set this is again time consuming to move my selection back over a number of columns.

By using keyboard shortcuts (including Alt + menu commands), is there a way to achieve what I'm looking for? Basically, I want to replicate what happens if I were to double click the fill handle (where it would autofill B3 to B11 for me), without using a mouse.

Sorry if this is a stupid question, just a lasting frustration for me.

try :

Hold shift + Page down

No luck, this again extends the selection below the dataset.

Damned, that doesn't match my experience of excel-kind programs...

So I'm also curious if someone has an answer.

if you want to start at the top, can you first go to the bottom-most row of interest, then shift + page up?

This post was edited by carteblanche on Nov 14 2018 06:21pm

I could do that using Ctrl + Shift + Down on the adjacent column, navigate over, then hold Shift + Page Up, but that's not an ideal solution. Same goes for the Ctrl + Shift + End. Might try posting on Reddit Excel and see if they know.

Ctrl + C (the element that has the formula you want to copy - B1 in this case)
Shift + Down/page down (select rows you want to have the formula)
Ctrl + V (Will paste the formula to all elements selected and will automatically use the correct row for the formula)

Am I just not understanding the request correctly? Or are you looking for a shorter shortcut that does the same thing?

This post was edited by kasey21 on Nov 15 2018 01:11am

The example I provided is a simple version, but I work with datasets of 10000+ rows, so holding shift + down or page down is time consuming. If you double click the fill handle, it would intelligently autofill to the last row of data. Looking for a keyboard alternative if it exists. Posted on r/excel so might get an answer there also if you want to look

Can't you just use Ctrl + Shift + End. Then Shift + left arrow to select the actual column you want to work with? . As long as your starting position is in the correct column this should work.

If your in cell b2

Right arrow
Cntrl+ down arrow
Left arrow
Cntrl+shift+up arrow
Cntrl + d

Takes literally one-2 seconds to navigate through most large datasets and insert formulas in this manner if you dislike mouse.

This post was edited by Xx Shin3d0wn xX on Jan 8 2019 12:54am