# Questions tagged [excel-auto-fill]

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

8
questions

**1**

vote

**0**answers

23 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

52 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

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

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

**0**

votes

**1**answer

28 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

444 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

**2**answers

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

**11**

votes

**9**answers

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