Do you have any Excel OCD habits?

[Domski]

I do some of my best conceiving when intoxicated

Dom

 

[HalfAce]

then it takes hours of tracing to find an utterly illogical error that one would never concieve of even if intoxicated.

And NOBODY will admit to having made any changes!!!

I do some of my best conceiving when intoxicated

I hear that!
Most all of my more complicated workbooks have been designed & written in this 'condition'.
(And no, don't get the wrong idea, I do a lot of my 'creating' at home.)
The biggest problem that causes is having to troubleshoot something at work where I'm not allowed to 'return to the state I was in' when I wrote it!

 

[JamesW]

This webcomic sums up drinking and programming:

http://xkcd.com/323/

 

[HalfAce]

Drinking???
I never said anything about drinking...

 

[SydneyGeek]

So is there possibly anything left to be OCD about? You've got all mine, well the top 50 or so.

Prolly all I could add is to point out is my abhorance of "the meddling boss" or "aspiring underling" who hacks your sheets when your not around and then wonders why, a week later, something doesn't work. then it takes hours of tracing to find an utterly illogical error that one would never concieve of even if intoxicated.

...More often than not, they have typed a value over a formula. Next time it doesn't update and they tell you it's broken. ALT+EGSF is a great time saver.

Denis

 

[Jon von der Heyden]

Hi Denis

ALT+EG = F5

 

[SydneyGeek]

Yep. But by running those 4 keys I can highlight all the formulas and find where people have stuffed up

Just a habit of mine...

Denis

 

[steve case]

I had to Google "OCD acronym" Is there some reason people use alphabet soup in place of real words?

 

[Domski]

Is there some reason people use alphabet soup in place of real words?

It's a compulsive obsession of mine!!!

Dom

 

[RoryA]

Another ironic signature, I see.