# Linked Questions

11 questions linked to/from Excel Auto-Fill a Series Without Mouse (Keyboard Only)

**0**

votes

**1**answer

11k views

### How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]

If I press CRTL+Down I move to the cell before the empty cell.
If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell.
Now if I want to auto fill ...

**1**

vote

**1**answer

193 views

### Excel copy downwards [duplicate]

In MS Excel, if you select two cells containing text like "x1", "x2" and drag the bottom-right corner of the selection, it continues the pattern "x3", "x4", "x5" etc.
Is there a way to do this using ...

**10**

votes

**4**answers

60k views

### AutoFill Large Number of Cells in Excel?

I have a formula in Excel that I would like to autofill to 999,999 other cells. How can I do this without dragging the autofill handle down the entire sheet?

**9**

votes

**2**answers

30k views

### Fill a large range with a formula in Excel, without mouse-dragging to extend

I have 5000 elements in column A and 5000 in column B
I want the element wise difference and stored in column C.
The subtraction command I know is =A1-B1 then drag all the way down with a mouse.
...

**1**

vote

**1**answer

14k views

### Is there a way to autofill cells in Excel 2013 with keyboard shortcuts? [duplicate]

So very shortly, I want a shortcut equivalent to dragging the little handle in the right-bottom in a cell-selection portion in Excel 2013 (for Windows).
There is many similar questions on the site, ...

**4**

votes

**3**answers

9k views

### 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 ...

**0**

votes

**3**answers

1k views

### How to fill a large series (over 10,000 rows) in Microsoft Excel without dragging or selecting cells?

I have more than 10,000 rows of data I need to do some calculations on one column of the data. I have made the calculation in one cell and now need to fill the formula for the calculation and all the ...

**1**

vote

**3**answers

419 views

### apply a formula to a very long column excel WITHOUT dragging

I would like to apply the formula n/log(n) to a very large number of inputs in excel. specifically across a column with 10,000 numbers in it. What is the most efficient way to do this without dragging?...

**1**

vote

**1**answer

808 views

### How to extend a a sequential pattern in Excel without using a mouse?

I would like to extend a sequential pattern in Excel as in the link below.
http://www.worldstart.com/ms-excel-extending-your-sequential-pattern/
However, is there a way to do that without using a ...

**0**

votes

**1**answer

1k views

### Excel: Using keyboard to replicate functionality of clicking bottom right corner of box to autofill

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 ...

**-1**

votes

**1**answer

121 views

### auto-fill a formula referring to table columns without mouse (keyboard only)

I'm working with formulas summarizing table columns (e.g. SUM(Table1[Column1]) and I would like to fill the formula to the right using only the keyboard.
When I autofill my range by mouse drag, it ...