Forum Discussion
Excel Fills cells when formula needs to be altered
Help!
In my Excel workbook, I have 12 tabs of worksheets, and each has been constructed with cells that contain formulas.
When I select a cell that needs to have the formula altered, hitting the equal sign causes Excel to fill the cell I selected and the cell to the right. Also, sometimes it will fill the selected cell and the cell to the right and the cell above the selected cell and the cell to the right of that one. Meaning, it fills 4 cells.
None of the filled cells can then be selected for use in the formula.
I've noticed that enlarging the magnification of the display will sometimes alter the number of cells affected.
See examples below...
Anyone have any thoughts on this. It's an annoying anomality
Thanks for any help!.
9 Replies
I'm suspecting that these are not just random cells, but are cells in an Excel table. Tables will sometimes exhibit some of the behaviors you're describing. And for the most part, you shouldn't be changing formulas IN a table.
But frankly it's hard to diagnose without being able to see and work with the actual "patient."
Unless the workbook in question contains confidential information of some kind, you'd help us help you by posting a copy of the actual workbook on OneDrive or GoogleDrive with a link pasted here that grants edit access to it.
