Linked Questions

78 votes
21 answers
613k views

Excel Auto-Fill a Series Without Mouse (Keyboard Only)

When I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then attempt ...
jtpereyda's user avatar
  • 2,467
32 votes
9 answers
304k views

Apply formula to a range of cells without drag and drop

Typically, in Excel, one can autofill a column by drag a cell down. However, with a lot of cells to fill up, manually dragging and scrolling the spreadsheet is time consuming. Is there a much better ...
Graviton's user avatar
  • 5,680
13 votes
5 answers
102k 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?
Josh's user avatar
  • 139
12 votes
9 answers
170k views

How to make Excel 2010 auto-fill new row with formulas?

I can swear that I have seen that behaviour where Excel automatically fills in a newly inserted row with the same formula as on the row above. I know this can be done with some VBA, but if possible I'...
RipperDoc's user avatar
  • 457
6 votes
4 answers
33k 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 ...
Ramana's user avatar
  • 211
3 votes
4 answers
12k 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?...
user1011104's user avatar
1 vote
1 answer
15k 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, ...
MahNas92's user avatar
  • 343
-2 votes
1 answer
490 views

Excel 2010 - possible to apply a function to an entire column?

In Excel 2010, is it possible to apply a function (not a formula) to an entire column (without dragging the plus symbol all the way to the bottom)?
Confuzzled's user avatar
2 votes
1 answer
118 views

Is there something about filling Excel spreadsheet cells with CTRL+SHIFT+ENTER that prevents a successful sort?

I have a long list of entries that I want to sort randomly. I highlighted a column, typed in =RAND(), and then pressed CTRL+SHIFT+ENTER, and voilà, my column was filled with random numbers. I then ...
Lisa Beck's user avatar
  • 203
0 votes
1 answer
200 views

Apply formula to all rows in a column from data table

I'm trying to process data in CSV format using Excel. I can import the CSV file, but I need to process this data in various ways. For example, I have a coloumn of hex values that need to be plotted. ...
r_fault's user avatar
  • 11