Questions tagged [excel-auto-fill]
The excel-auto-fill tag has no usage guidance, but it has a tag wiki.
20
questions
0
votes
0
answers
19
views
Auto adjust cell values if one cell values changed
how to adjust values automatically if cell values A1 has changed means then the changed values has to adjusted with B2 values and the final cumulative values remains unchanged.
Suppose i have list of ...
0
votes
0
answers
30
views
When I move a cell to another location, the original location cell fills with yellow. How do I change this default?
When I drag a cell to another location within the spreadsheet, the original location cell fills with yellow by default. I cannot figure out how to change this default setting to "no fill". ...
0
votes
1
answer
35
views
Automating Autofill in Excel
Is there a way to automate autofill in Excel with say a function or something along those lines? I need a function I currently have to autofill down a certain number of rows depending on the user's ...
0
votes
1
answer
38
views
Can you turn the data from an excel file to a neatly laid out word document
I work for an educational NGO and every year/term we make new reosurce packs for teachers. The resouce packs include new lesson plans and a number of word documents which basically summarise the ...
0
votes
1
answer
58
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 ...
1
vote
1
answer
18
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
66
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
241
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
54
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
478
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
156
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
321
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
2
answers
6k
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
525
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
38
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
16k
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
57
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!!
1
vote
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
975
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
164k
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'...