Questions tagged [excel-auto-fill]
The excel-auto-fill tag has no usage guidance, but it has a tag wiki.
17
questions
0
votes
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
4answers
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
3answers
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
9answers
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'...
