# Questions tagged [excel-auto-fill]

The excel-auto-fill tag has no usage guidance, but it has a tag wiki.

17
questions

**0**

votes

**1**answer

23 views

### Autofill down variable number of rows in a macro

Here is a mock version of my data. There are two worksheets:
and
Column A is a TEXTJOIN function. The rest is filled in manually with the exception of the year. I want to get the year by using a ...

**0**

votes

**0**answers

22 views

### How to auto fill a column with increment until we found another value and start from there

I have data like this:
1
_
_
_
_
1
_
_
_
_ (It's a column)
I need the data to be filled in increments like this:
1
2
3
4
5
1
2
3
4
5 (It's a column)
Is there any quick/bulk way to do it? (If we have ...

**1**

vote

**1**answer

10 views

### How do I join 2 horizontal cells' content in excel

I have a sheet and i want to join the content of each two consecutive cells in one column to a new column like this:
=A1&" "&A2
=A3&" "&A4
=A5&" "&...

**0**

votes

**1**answer

62 views

### Creating “semi-regular” lists of dates in Excel

Consider the Excel power user club of Wheatland, Wyoming. The club meets evey Thursday, plus every second Monday. So there are, alternating, weeks with two, and weeks with only one meeting. Let us ...

**1**

vote

**1**answer

41 views

### Excel column auto-populates in newly inserted rows

Hopefully this makes sense.
In Excel, I have a table with 12 columns. Column A is a file number hyperlink that takes you directly to the specified job folder on our server. When I insert new rows ...

**1**

vote

**0**answers

47 views

### Excel error - Autofill changes first/initial formula

I am having an issue with autofill in Excel 2016.
When I use autofill, a reference in the first/initial formula changes unexpectedly (see "Excel autofill issue" gif link above). The reference to "...

**5**

votes

**1**answer

342 views

### How to Autofill Excel cells relatively with absolute formulas

I have two sheets "Data" and "Main" where the "Data" spreadsheet reads from an external source and automatically updates. The "Main" is set up right now so that each cell references the corresponding ...

**2**

votes

**4**answers

119 views

### How to automatically fill range in excel by interpolating between lower and upper bounds

I want to interpolate between A00-B99 and have excel expand the series to A00, A01, A02,.... all the way to B99.
SO if I have A00 in one cell and want to have excel automatically fill down to B99, ...

**1**

vote

**1**answer

177 views

### Excel 2010 autofill option by entering last four digits of 10 digit number how to

I'm having list of 1000 numbers (10 digits) in each rows, need to get(retrieve) that particular number from that data by entering last four digits alone..
Just I have to retrieve the 10 digits by ...

**2**

votes

**1**answer

3k views

### Are Excel table headers always converted to text?

I am trying to get table headers containing dates to auto-fill properly, so that they increase by one day between columns.
Unfortunately, Excel seems to treat table headers as text regardless of the ...

**0**

votes

**1**answer

315 views

### Excel: Autofill sequential groups of formulas

I have groups of formulas in Excel 2016:
=CLASSSTRUCTURE!B43
=CLASSSTRUCTURE!B43
=CLASSSTRUCTURE!B43
=CLASSSTRUCTURE!B43
=CLASSSTRUCTURE!B44
=CLASSSTRUCTURE!B44
=CLASSSTRUCTURE!B44
=CLASSSTRUCTURE!...

**0**

votes

**1**answer

31 views

### Autofill the months as we do for days of the week

When you type let's say Monday and Tuesday to the 2 cells in the same column back to back (i.e. Monday to A1, Tuesday to A2), when you drag it with auto-fill option, it would fill in the other days ...

**4**

votes

**3**answers

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

**0**

votes

**1**answer

38 views

### Excel - How to fill a certain amount of cells/rows with the same text?

Imagine you have a random text at the first cell and want to fill the next X cells/rows (e.g: 104 cells) with the same text. Is it a way to solve this without coping-pasting?
Thanks in advance!!

**0**

votes

**1**answer

1k views

### Excel autofill inconsistent

I'm working in an excel spreadsheet that I add data to each day as new data comes in. Some columns are formulas calculating things based on the new data. Some of these columns have managed to ...

**1**

vote

**3**answers

807 views

### Auto fill letters in Excel 2010

I want to make a list with the letters A...Z. Is it possible to do that with the auto fill feature through drag&drop or auto fill through the menu? For example if I use A, B, C as a "starting list"...

**12**

votes

**9**answers

159k 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'...