1

When you click the bottom right corner of a selected cell, excel autofills down the column until the end of an adjacent column's data.

I primarily use CTRL+Down, then CTRL+D, but this will autofill until the end of that column's data, not the adjacent one.

How do I do what happens when you click the bottom right corner using only the keyboard?

user7758051
  • 175

1 Answers1

0

With data like:

enter image description here

manually (no mouse, only keyboard):

Write the item in the first cell
Use the Shift+down arrow key to select all the cells you want to fill.
Touch F2 key to bring the cursor in the first cell.
Touch Ctrl + Enter

or with this macro:

Sub mimic()
    Dim N As Long
    N = Cells(Rows.Count, "A").End(xlUp).Row
    Range("B1").AutoFill Destination:=Range("B1:B" & N)
End Sub

will perform the fill-down:

enter image description here

To learn more about being mouse-less see:

All Answers

Gary's Student
  • 19,636