Linked Questions

0
votes
1answer
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
1answer
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
4answers
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
2answers
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
1answer
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
3answers
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
3answers
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
3answers
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
1answer
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
1answer
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
1answer
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 ...