Show selected cells, rows, columns when window is inactive
Currently selected cells, rows, and columns are invisible when the Excel window is inactive and another window is in the foreground. I would rather have selected cells in an inactive window be visually highlighted, perhaps with a special inactive color, rather than be invisible. This would help me cross-reference information from other programs with large Excel spreadsheets.
Yvon Hache commented
I totally agree.
This was definitely possible a good while ago - probably back n the days of Windows 98. It's absurd that I can't see what I've selected if, for example, I'm trying to compare data in two separate workbooks.
SEUMAS MACLAREN commented
AGREED. There is no proper usability reason for removing the sheet highlight when the Excel application window instance is not in the foreground. Why is this the case? For example, I often require to look at a complex sheet when writing a Word report on the data, or compare sheets, and need to keep my sheet highlighted to see what I am checking whilst working on the other document. This now ubiquitous behaviour in Windows has no user-friendly reason and should be, MUST be removed for common sense. All experienced users, will I am sure agree. It is only beginners who lose the sense of what is actually in the foreground.
these votes would be better added to previous similar comment: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10551846-visually-show-which-cells-are-selected-even-when-a
Agreed, I can't believe there aren't more votes on this. So often I laboriously look for a line in Excel on my second screen,and select it, to highlight some information to use on my other screen, and when I shift focus the selection disappears! Annoying, and for no good reason at all. Nothing gained.
This is also useful for multiple-display systems - I have to keep one hand on the scree to keep my position when I'm in another program looking that information up.