These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website. This is my first need to post on a Excel Forum as I've always found help or answers from other peeps or internet but this one is making me scratch my head big time.The Real Statistics Resource Pack contains a variety of supplemental functions and data analysis tools not provided by Excel. There's about 50+ cells that need referencing and I got to get this done for work. I wonder if I've picked up some legacy protection from the original form but can't see anywhere in the tools etc that's obvious. I can't imagine why it's doing this and I've never seen it happen before.įormatting cells, giving cells names rather than the usually adequate of reference to the Cell Number doesn't change things.
I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result. I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc. I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me. Which is the only current way I can get rid of it. Is there some shortcut to turn off this highlight feature other than restarting The cursor is still stuck in the highlighting mode and won't perform anyĭo you think this is a problem with my computer, the excel program? I have changed my mouse and this didn't help. I can close it only with the task manager but when I open it again, I can't select anything from the tool bars, do any work on the sheet or close the program. The biggest problem is that the highlighting won't turn off, no matter When I return to excel thousands and thousands of cells are blue.
I move even in those other programs (I know this sounds confusing). Program on my computer, that excel page keeps highlighting wherever The cell turns blue and then wherever I move, it highlights those to.
I will click on a cell to add information.
0 kommentar(er)
