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 eq...
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.
https://1drv.ms/x/s!AhVEtMGoFprYgzsuPkZUuzb0Raxq?e=HNloTG
- Thanks for the reply.
I tried to put the link in but I'm not sure it worked. It includes a sample of the spreadsheet, and you need to scroll down to where the formulas are. You see them by the cells that contain zeroes.