Basically, checking is very very important to my line of work. Technically, every cell of every spreadsheet should be checked, but this is not feasible. If I am checking something, I can often tell when the user has built a nice formula and copied to the other cells in a contiguous block. But I can never be 100% sure, and if I find one anomaly, I lose trust and end up checking every cell just to be sure.
I have come up with ways of doing this check quickly. Basically, I copy the value of the original cells somewhere else and then pick one of the cells and copy its formula over all the others and then taking the difference of the new group and the values of the old group. If it is zero, I'm good to go. I'm pretty fast at this, but it is pretty tedious. Are there any add-ins or other methods that would help me do this faster. Like, if I highlighted a group of cells, I could just see they were equivalent down by the status bar next to where it shows sum, average, etc.