Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL functionality
I seem to recall that there is some feature in EXCEL that will alert you to the fact that a cell's formula appears different from that of its neighbors. For example, if you copied a formula across a row and then, for testing purposes, overwrote one of the cells with a value, then forgot to change it back to the formula, it would alert you to that.
Can anyone remind me of what that might be? Thanks! Dean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL functionality
Try this:
From the Excel main menu: <tools<options<error checking tab Check: Enable background error checking Check: Inconsistent formula in region Does that help? *********** Regards, Ron XL2002, WinXP "Dean" wrote: I seem to recall that there is some feature in EXCEL that will alert you to the fact that a cell's formula appears different from that of its neighbors. For example, if you copied a formula across a row and then, for testing purposes, overwrote one of the cells with a value, then forgot to change it back to the formula, it would alert you to that. Can anyone remind me of what that might be? Thanks! Dean |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL functionality
Yup, that does it!
Actually, it does not seem as powerful as I'd hoped. If you have copied a formula across a row and accidentally replace one of the cells with its value, since a value is not a formula per se, it doesn't seem to object (actually, if I put =0, rather than just 0, it seems to object just fine). Does that seem right to you? Also, I think you have to have sheets unprotected for it to work. Still it's nice to have. One other question: Rather than have to look thru every cell for that green triangle marker, is there a way to see all such identified inconsistent cells somehow in a list or table? Thanks much! Dean "Ron Coderre" wrote in message ... Try this: From the Excel main menu: <tools<options<error checking tab Check: Enable background error checking Check: Inconsistent formula in region Does that help? *********** Regards, Ron XL2002, WinXP "Dean" wrote: I seem to recall that there is some feature in EXCEL that will alert you to the fact that a cell's formula appears different from that of its neighbors. For example, if you copied a formula across a row and then, for testing purposes, overwrote one of the cells with a value, then forgot to change it back to the formula, it would alert you to that. Can anyone remind me of what that might be? Thanks! Dean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost arrow functionality within Excel | Excel Discussion (Misc queries) | |||
form with excel and word functionality | Excel Discussion (Misc queries) | |||
How Safe is the Excel Password functionality? | Excel Programming | |||
new excel vba functionality | Excel Programming | |||
Template functionality in Excel | Excel Discussion (Misc queries) |