a pet peeve / desire with conditional formatting editing

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
Just about every time I hand-edit a condition I get killed by the arrow key behavior, which doesn't work as an edit key, but infuriatingly causes unwanted cell references to be inserted to the condition. If this isn't described well enough, just try using an arrow key in any text box and watch, while editing any existing conditional format. (Even control-arrow keys are screwed thusly! Nice work catching that one, Microsoft Deproductivity Development Team!)

I have a workaround, but my question is if the behavior itself can be defeated - and if not, is there a better workaround than mine.

FWIW the workaround is to tab to the text box of concern and immediately hit Ctrl-C, and paste to an external app. like Word (or Notepad, if you don't mind the weaker Control-arrow behavior).
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Gates Is Antichrist said:
Just about every time I hand-edit a condition I get killed by the arrow key behavior, which doesn't work as an edit key, but infuriatingly causes unwanted cell references to be inserted to the condition. If this isn't described well enough, just try using an arrow key and watch, while editing any existing conditional format. (Even control-arrow keys are screwed thusly! Nice work catching that one, Microsoft Deproductivity Development Team!)

I have a workaround, but my question is if the behavior itself can be defeated - and if not, is there a better workaround than mine.

FWIW the workaround is to tab to the text box of concern and immediately hit Ctrl-C, and paste to an external app. like Word (or Notepad, if you don't mind the weaker Control-arrow behavior).

Yes, it is a terrible thing, also in the Refers to box of Insert|Name|Define.

First hit F2 then activate movement keys...
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
A similar behaviour also happens in the formula bar.

I've lost count how many times when I'm entering a concatenation formula, hit space and ended up with an unwanted reference to the entire row. eg 2:2
 

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
Aladin: Awesome. Awesome. Thanks! F2 - whoda thunk it was that easy. What an enormous timesaver you've given me/us with that one.
 

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
Norie, the one that kills me is having the shift key down for 1 millionth of a second too long after typing an ampersand - which is followed by space bar. Typing shift-spacebar screws me over and over.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,011
Messages
5,569,610
Members
412,282
Latest member
bobHenk
Top