How to auto-fill a numbered series WITHOUT a mouse (keyboard only) on Google Sheets [closed]
Is there a way to fill down a series using just the keyboard instead of the mouse? This is that function where you highlight a group of cells, then click on the bottom right corner of the highlighted box, and drag down with the mouse to make a series list.
I've found shortcuts to do this in Excel: Excel Auto-Fill a Series Without Mouse (Keyboard Only) but they don't work on Google Sheets.
I have some wrist issues and have been minimizing mouse usage as a result. I'd appreciate hearing about some shortcuts since I need to do this every day! Thank you!
If you just want to increment numbers as you go down a column, say from A1 to A100, so that you have the number 1 in A1 and the number 100 in A100, you could
- Type the number 1 (or whatever number you want to start with) in cell A1.
- Type the formula
=A1+1
in cell A2. This will put the number 2 in cell A2. Use the step (increment) value you want here. For example, if you want the series 10, 13, 16, 19, 22, 25, …, enter10
in A1 and=A1+3
in A2. - Go to cell A2 using the cursor keys on the keyboard.
- With the cell A2 now highlighted, while holding down a Shift key, use the down arrow key on the keyboard to get to the last cell where you want your series to end. You can then release the Shift key. This selects all cells from A2 to the end.
- Hit Ctrl+D. This will copy the formula from A2 down through all the selected cells, so that in cell A100 you would have the formula
=A99+1
, which will put the value 100 in cell A100. - (Optional) Hit Ctrl+C and then Ctrl+Shift+V. This will copy the already-selected cells and then paste only their values, as opposed to the formulas that were there at the end of step 5.