Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel has an annoying habit of making the current selection invisible when it becomes inactive - including the "focused cell" rectangle. When I try to process a spreadsheet in a certain way I may put it on a secondary monitor and highlight the stuff I'm working with, but the moment I switch to another program (on the primary screen) I can no longer see where I was.

It must have made sense 10 years ago before lots of people had multiple monitors, but now it's just an annoyance. A quick google doesn't find anything at all on this.

share|improve this question
up vote 1 down vote accepted

I have been annoyed by this for years. I've never found a solution within Excel. Is it an option to open your spreadsheet (at least for reading, if not editing) in Calc? It doesn't suffer the same problem.

share|improve this answer
I suppose I could... but it's too much trouble just for this. I end up making the cell(s) bold and hoping it's "visible enough". – romkyns Jan 25 '10 at 22:18
At any given time I typically have both installed anyway, so (for me at least) it's not any extra trouble. – JMD Jan 25 '10 at 22:41

Agree that this an annoyance. One option is a row highlighting add-in. I like Chip Pearsons

Maybe overkill, but it's something.

share|improve this answer
The "known issues" are quite severe... – romkyns Jan 25 '10 at 23:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.