Tuesday, June 6, 2017

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.


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.


Answer



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


No comments:

Post a Comment

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...