Super User
Super User

Questions tagged [excel-auto-fill]

The Microsoft Excel Auto Fill feature can be used to fill cells with data that follows a pattern or that is based on data in other cells.

23 questions
12
votes
9 answers

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'd like to find what triggers this to happen…
RipperDoc
  • 457
8
votes
4 answers

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 cells. Usually I just select the cells using the…
Ramana
  • 231
5
votes
1 answer

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 cell in the "Data" sheet, i.e. A1 in "Main" reads…
Nahmid
  • 153
4
votes
2 answers

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 actual cell formatting, so attempting to fill a…
Mr Ethernet
  • 4,459
2
votes
4 answers

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, how would I do this? Thanks!
user1117807
  • 31
1
vote
1 answer

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&" "&A6 ... But when I try to Auto-fill it doesn't get the pattern right. It messes up in many cells and…
Roo Tenshi
  • 23
  • 1
  • 7
1
vote
1 answer

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 into this table, no matter how many rows I insert,…
Joshua Huff
  • 11
1
vote
0 answers

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 "AA4" should remain in the first formula and should…
Jos
  • 11
  • 3
1
vote
1 answer

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 simply enter last 4 digits in another rows Ps…
Yuvaraj Aravind
  • 11
1
vote
1 answer

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 automatically copy the formula for the past several days…
Elliott
  • 11
1
vote
3 answers

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". I tried various combination of selecting A-C and…
Albin
  • 11,950
0
votes
1 answer

Auto Stoplight Colored Chart

Does anyone have code that will automatically color a traffic light-type icon for a red-yellow-green status? The only way I know how to do this is with multiple steps that have to be replicated each time. I would like, for example, when the letters…
Sheel
  • 1
0
votes
1 answer

When saving as a PDF document, Excel uses your name as the author for the PDF doc - How to stop it doing this?

I create PDF invoices for my clients from a template I created in Excel. Rather annoyingly, Excel is auto-populating my name in the 'Author' field for the PDF document. The only way to remove it is to edit the PDF document afterwards and manually…
Dirkrs
  • 1
0
votes
2 answers

Pull data from 1 worksheet into another automatically

I need a way to get information from worksheets AAA, BBB, CCC, etc. into the Summary Worksheet. Each worksheet Name will be listed in the Summary Worksheet, column A and in each worksheet in F1 (not shown in image). As new worksheets are added,…
Pat
  • 36
0
votes
2 answers

Excel - Auto fill a specific number of months in a table

I am making a leasing table where I would like to be able to enter a start date and number of months in a term. I would like the table to return the data in a format that begins with the term start date in 12 month increments for example 120 months…
Rogue Darko
  • 1
1
2