Questions tagged [excel-auto-fill]

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

Filter by
Sorted by
Tagged with
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 ...
user avatar
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". ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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&" "&...
user avatar
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 ...
user avatar
  • 103
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 ...
user avatar
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 "...
user avatar
  • 11
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 ...
user avatar
  • 153
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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 4,013
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!...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 181
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!!
user avatar
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 ...
user avatar
  • 11
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"...
user avatar
  • 7,970
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'...
user avatar
  • 457