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).
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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,344
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,111
Messages
5,835,450
Members
430,357
Latest member
Greshapa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top