I know lots of techniques to remove trailing spaces from cells in Excel (e.g.
TRIM), but sometimes I get given large sheets from other people which contain trailing spaces in dangerous places, where it's not obvious there's a problem because the trailing spaces exist in multiple places (so lookups etc still work) - but those trailing spaces cause unexpected problems later.
In Word and various publishing applications, there are options to show invisible characters. For example, in Word, it's called "Show non-printing characters", and it looks like this:
And text editors often show invisible characters in selected text, for example from Sublime Text 2:
Is there any kind of setting in Excel whereby invisible characters like trailing spaces could become visible? I'm not fussy about how they become visible, just that they do, across the whole sheet (i.e. not just in one selected cell).