G
Guest
Hello all,
I have repeatedly used the Autofill tool in the past, but the past couple
days the function no longer works. I'm afraid I've checked a box somewhere or
done something to deactive this function.
Here is an example of how I've used autofill in the past. It is not this
simplistic in real life but for the sake of an easy example:
Column "A" is numbers, 100 through 110
Column "B" is the letter M
Column C1, I create the formula =(A1&""&B1) to merge the two cells and
create the text of 100M in cell C1.
Then, I would use the Fill Handle to copy the formula down through cell C10.
In the past, this would populate the C column with the formula, so that I
would end up in the C column with a sequential list of 100M through 110M.
However, just recently it started COPYING whatever was in cell C1 to the
whole column below, while at the same time copying the formula correctly. So,
I would end up with the value of cell C1 (which in this case is 100M) being
placed in C1 through C10. BUT, if I click into, say C5, the formula displays
correctly as =(A5&""&B5). If I press enter, it then calculates the formula
and corrects the contents of C5. So to get a correct list I have to put my
curser in C2 through C10, one at a time, click into the box, and press enter.
Then I have the correct list.
In trying to resolve this, I've tried right-clicking on the Fill Handle, but
I only have the option to "Copy Cells", "Fill Formatting Only", and "Fill
Without Formatting". The option to "Fill Series" is grayed out.
These are the same options that appear if I left-click and drag down the
Fill Handle.
I'm out of ideas and my lists are now taking forever to create rather than
the two minutes it used to take. Thanks for your help.
I have repeatedly used the Autofill tool in the past, but the past couple
days the function no longer works. I'm afraid I've checked a box somewhere or
done something to deactive this function.
Here is an example of how I've used autofill in the past. It is not this
simplistic in real life but for the sake of an easy example:
Column "A" is numbers, 100 through 110
Column "B" is the letter M
Column C1, I create the formula =(A1&""&B1) to merge the two cells and
create the text of 100M in cell C1.
Then, I would use the Fill Handle to copy the formula down through cell C10.
In the past, this would populate the C column with the formula, so that I
would end up in the C column with a sequential list of 100M through 110M.
However, just recently it started COPYING whatever was in cell C1 to the
whole column below, while at the same time copying the formula correctly. So,
I would end up with the value of cell C1 (which in this case is 100M) being
placed in C1 through C10. BUT, if I click into, say C5, the formula displays
correctly as =(A5&""&B5). If I press enter, it then calculates the formula
and corrects the contents of C5. So to get a correct list I have to put my
curser in C2 through C10, one at a time, click into the box, and press enter.
Then I have the correct list.
In trying to resolve this, I've tried right-clicking on the Fill Handle, but
I only have the option to "Copy Cells", "Fill Formatting Only", and "Fill
Without Formatting". The option to "Fill Series" is grayed out.
These are the same options that appear if I left-click and drag down the
Fill Handle.
I'm out of ideas and my lists are now taking forever to create rather than
the two minutes it used to take. Thanks for your help.