Linked Questions
10 questions linked to/from Fill a large range with a formula in Excel, without mouse-dragging to extend
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 ...
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 ...
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?
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'...
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 ...
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?...
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, ...
-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)?
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 ...
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. ...