Visually show which cells are selected even when another application has focus
Currently, when I select one or more cells and then switch to another application, the boundary box and shading for the selected cells are not shown. Other Office applications exhibit this behavior as well--selection highlighting is only displayed when the program has focus. Many (most?) non-Office applications show the highlighting at all times.
It would be far more useful to be able to glance at the spreadsheet and see which cells are selected, even when working in another program.
Thanks for the continued interest in this! We will continue to monitor this suggestion and prioritize it as appropriate with the other suggestions in the forum.
Thanks for taking the time to tell us about changes you’d like to see – we’re listening.
No you ain't.
We’ll take a look at this one.
No you won't.
Folks should keep voting for the things they like the most.
No we shouldn't.
We’ll generally be prioritizing things according to the number of votes they get.
No you won't.
John Nicholl commented
Yeah this has been on here nearly 4 years. So pleased they are listening. Excel is such a bad app. You ever tried opening another work book while your current workbook has a cell in edit mode!
Bachowny Plamborgs commented
This kind of thing just proves that Microsoft has absolutely no idea what users need. This is something that people will struggle with after about 5 minutes of using Excel and yet it seems like they are surprised that anyone might need this.
Yay, four year old Admin comment, bet this one is at the top of their list, no matter how many votes it gets, absolute top of their list, yes sir.
When the age of the Admin comment (assuming there even is one) gets near to being written in digits, not text, in proper English, you know they care very much.
Also the column heading and row number spaces have a slightly darker grey to indicate the selected cells. Please bring back the yellow/golden colors from 2007 or, even better, allow to choose it from the Options menu.
Mike D commented
This "Feature" is terribly inefficient when using multiple monitors. I am constantly working between multiple spreadsheets and the inability to see what I've selected in one while working in another increases my mistakes and makes me much less efficient. Having to put a finger on my screen or taking a screenshot of an open application is a clunky and obtrusive workaround for something that should be simple. It's a shame that someone spent time to make this work, in direct contrast with the native behavior of every other application I've used, but it's a counter-intuitive UI choice that burdens the end-user.
I can't believe how not intuitive Excel is becoming and how every default behavior do not work.
This is just one example amongst many
Almost 3 years later........
Time to use Open Office
Been wanting this for years!
This is the one thing everyone wants. Just do it. What were you thinking when you decided not to display the selection?
Dont waste your time. Microsoft stopped caring long time ago.
Jordon Pilling commented
Please please please add this, or at least make it an option, would save me so much time having to re-focus window to see selection. You dont even need to keep it selected as that would break ActiveWIndow VBA etc, just change the cell colours, or border box them, or something. Ta :)
John Nicholl commented
Please bring this feature back to Excel. I often have to reference my spread sheet when working in another application, I select the rows I wish to read when I give the other application focus find where I need the data and then look at the other screen with Excel to find the highlight has gone is a major frustration. I have had to revert to writing the data I need in a note pad then go to the other application and add the data by referencing my note pad!
Ed Hansberry commented
@oz - how would being in another app, like Chrome or Outlook, be affected if Excel, on another screen or window, still visually show the selected cells? I often highlight relevant cells and would like to compose an email based on that info, but cannot because the highlight vanishes until I return to Excel. it forces me to color those cells, then uncolor them when done.
But I am genuinely curious as to how the highlight continuing on even when the app is not in focus is a disruption to your work flow.
This seems to be an MS only thing. Other apps retain selection visually when you switch away.
Oz du Soleil commented
I absolutely HATE this idea. When I move away from something I want to be done with it. I can see someone else's need for it, and I'd like for them to be able to work better, but this sounds like something that would be an annoyance for me and how I work.
Paige A. commented
I definately second this. Not seeing a selection is a HUGE problem for me as I am working.
This is a great idea. I'd also like to see the COUNT/SUM/AVERAGE etc. display in the status bar when focus is moved away.
Joseph Becker commented
It would be helpful if a cell that you have clicked on in Excel stays highlighted (selected) when switching to another application (Word, Acrobat, etc.) for easy reference, especially when using dual monitors
So it's been a year since this was first asked, any updates John? thank you