The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [excel-auto-fill]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
1
vote
0answers
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
1answer
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
1answer
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
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 ...
0
votes
1answer
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
1answer
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
2answers
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
9answers
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'...