One Excel annoyance is that after you select a group of cells, you can’t unselect one of them. For example, you might want to format specific cells, or create a named range, and you accidentally include a cell that shouldn’t be in the group. You can’t click on that cell to unselect it – you have to start over, and select more carefully the next time.
To solve that problem, Doug Glancy has created a free tool that you can download — SelecTracker.
Next, we need a version that lets you unselect one cell within an large area, e.g. if you drag down from A2:A7, click on cell A5, to unselect it.
It’s almost Halloween, and perhaps you’re familiar with the horror story that I’m about to tell you. It’s a frightening tale of an Excel workbook that was destroyed forever, by a well-intentioned, but easily-distracted genius.