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

Mr. Snrub

Board Regular
Joined
May 22, 2005
Messages
129
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.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Mr. Snrub

Board Regular
Joined
May 22, 2005
Messages
129
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,194
Messages
5,546,487
Members
410,742
Latest member
WalterSil
Top