How to tell Excel not to hide selection when it becomes inactive?

How to tell Excel not to hide selection when it becomes inactive?

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.

Asked by: Guest | Views: 169

Total answers/comments: 2

Comments display order:

Guest [Entry]

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 OpenOfficedotorg Calc? It doesn't suffer the same problem.

Guest [Entry]

"I found the answer to almost the same question at How to keep selected text highlighted when focus changes in Microsoft Word/Excel to work best and simplest for me:

Just copy the selected cells, this circles the selection perimeter, which remains even when changing the focus to another application. The main weakness with this solution is that if you copy anything else to the clipboard, the perimeter dotted line goes away in Excel. But for the simplicity and effectiveness, just pressing Ctrl-C before changing focus has become my default solution to this problem. I'll highlight cells if I need a more robust solution, but then I need to remember to Undo in Excel before doing more work there."