Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When Excel window loses focus, the cursor becomes invisible. Also coloring of the respective column/row headers is back to default, so it's impossible to locate cursor and/or selection as soon as I switch to other window.

This annoys the hell out of me as it makes Excel almost unusable for most of tasks I need it for:

  • keeping track of test cases while performing testing in another window

  • obtaining data somewhere else and porting it to Excel

(I have never seen such behavior in other applications and can't even think of a justification for it.)

Is is possible to turn this behavior off, i.e. retain selection visibility when out of focus?

Edit: Contrary to what I thought when originally posted this, this is not a "new feature", it's rather a UI pragma that MS holds to in most their applications (at least since some point in time), although non-MS applications or some legacy MS applications do not always respect it.

share|improve this question

1 Answer 1

That is a normal behavior for Windows. It is not specific to Excel. The same thing happens if you select text in Word, then change windows. It can not be turned off.

If you are willing to add macros to your workbook, there is a work-around to highlight the row you need, then remove it when you are done. The highlighted row will show when the window does not have focus.

Add these pieces of code in the VBA Explorer (Alt+F11) to ThisWorkbook and you can either call them from macros (Alt+F8) or add buttons for them.

Sub RowHighlight()
  Rows(ActiveCell.Row).Select
  With Selection.Interior
    .Pattern = xlSolid
    .ColorIndex = 6  'Change this number to the color of choice.
  End With
End Sub

Sub RemHighlight()
  Rows(ActiveCell.Row).Select
  With Selection.Interior
    .Pattern = xlNone
  End With
End Sub

Below is an index of colors you can change in the code. Currently set to Yellow.

enter image description here

share|improve this answer
    
Interesting idea. You have to be careful doing this though because this will cause you to lose any fill formatting you have in the active row. Also, it would be more useful to have this associated with a worksheet event -- otherwise it would make more sense just to manually change the fill color every time you need to track your active cell while in another window. –  Excellll Nov 6 '12 at 17:26
    
"That is a normal behavior for Windows. It is not specific to Excel." You are right that it's not specific to Excel---indeed, Word behaves the same, but I would not call it normal. For example, it does not behave like this in Notepad or actually most programs I use (Notepad++, PSPad, Sumatra PDF reader). It does behave like this in native text fields like "Run...", though. (Soo weird I never noticed that.) –  Alois Mahdal Nov 6 '12 at 17:28
    
The OSX version of Excel is implemented in exactly the same way, limiting its usability as mentioned by the OP. –  rexford Aug 19 at 10:59

Your Answer

 
discard

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.