Forum Discussion
Excel cell fill doesn't work.... !
Hi,
I have all settings correct and still, randomly from time to time, for day or more,
I cannot fill cells with data. It just taking first number from first cell and copy it ignoring numbers below, and only what I can see are formatting options (this where you change in ex. colour depends on data in the cell. Nothing seems to work, I have no updates pending, reset Excel or computer doesn't work. I use Excel daily and if this happen I have 1 or more days out of work possibility.
What shall be fixed here?
Help, please.
12 Replies
Hi, thank you, but it is not an answer for the question that is made.
wrote here 1000 times the continuation and I cannot see any of my answer. the answer HansVogelaar is not solution for a problem I have described
wrote here 1000 times the continuation and I cannot see any of my answer. the answer HansVogelaar is not solution for a problem I have described
Reposted without cross-reference: https://learn.microsoft.com/en-us/answers/questions/5488242/my-excel-doesnt-fill-cells-with-series-i-know-how
wrote here 1000 times the continuation and I cannot see any of my answer. the answer HansVogelaar is not solution for a problem I have described
it seems you didn't read whole my question and didn't see picture, screenshots. Your answer is for users whose Excel works normally. Mine is not.
But it is not a solution, the paige told me to post on technical problems if I cannot find anwer on community solving. How I have already reply here, you are telling situation when Excel does work properly and my question is here because it doesn't work properly. Please, see picture I attached and read all my question before answering something obvious and related to the the situation that it is all working normal, because mine doesn't.
Hi. ye, this is how it works when it WORKS. But it DOESN'T. Please see on my picture, that I don't have possibility using the cell fill. I have only formatting options. Even if I use the cell filling from the menu, it doesn't fill up with series. This problem appears form me randomly, I never know when and for how long. Nothing helps and I am loosing days of work.
Shelby Davis what to do whit this bug?
Option #1:
- Enter 1 in a cell and 2 in the cell below it.
- Select both cells.
- Drag the fill handle in the lower right corner of the bottom cell downwards.
Option #2:
- Enter 1 in a cell.
- Use the right mouse button to drag the fill handle of the cell downwards.
- When you release the mouse button, select Fill Series from the popup menu.
ye, that is when it works, right.
But how I said it doesn't. Please have a look what sign I have on the picture when I try to do what you said. There is no fill option only formatting options. Even if I use option fill cell down from menu, it doesn't fill the series. And no, I cannot choose anything what you shows because this options doesn't exist from time to time, how I said in my post.
Thank you.
