How to add rows and fill cells using only the keyboard (no mouse).

[Mr. Snrub]

I am editing a table. My data looks as follows:

6/28/2018​	18.13​
6/29/2018​	18.09​
7/2/2018​	18.06​
7/3/2018​	18.2​
7/5/2018​	18.46​
7/6/2018​	18.74​
7/9/2018​	18.51​
7/10/2018​	18.6​

Since there are two days in between 6/29/2018 and 7/2/2018, I want to insert two rows. Step-by-step, this is what I do:

1. I use my mouse and highlight two rows below the 6/29/2018 cell.
2. I type Ctrl-Shift-= to add two rows.
3. I type the Up arrow to select the above cell.
4. I use my mouse and hover over the lower-right corner of the selected cell. The cursor turns into a plus sign (+).
5. I use my mouse and click and drag the cursor down to the two cells. This will auto-fill the correct date for the missing days.

Is there a way to do steps 1, 4, or 5 using the keyboard only? It is a pain having to move over the mouse all the time. In step 5, when I try to fill down the date cells (Ctrl-D), it doesn't increment the dates, it inserts the same date in the empty rows.

 

[Mr. Snrub]

I did this all wrong. What I should have done was created a second table with all days already entered (a simple autofill) and then have VLOOKUP or INDEX-MATCH functions to grab the dates from this table.