Venting!

[Smitty]

There are no bigger kids or tougher students than teachers...

That is so true...<!-- / message --><!-- sig -->

 

[MARK858]

Some of my colleagues center each and every cell in the spreadsheet. And I can't talk them out of it.
It drives me nuts.

1) Correct response to that is when they hit problems is to send it back to them saying you aren't touching it

2) A less correct response is if "1)" really isn't possible is to run the "Unmerge_CenterAcross" macro someone wrote a while back on the sheet (afraid I can't remember who wrote it). If you haven't got it I can repost it for you.
It un-merges the cells and then centres the text horizontally across the cell.

P.S. Option 1 is far and away the better option in my opinion

 

[ward376]

by accident left the screenupdating on (I think actually they are fascinated watching the flicker).

Hehe, yes I have seen first-hand that users are happier to giggle and watch flickering for some unnecessary 'select every row' loop rather than have the actions performed instantly in memory and go on to the next task.

Curse merged cells!
Clean up your recorded code!
Centering hinders data type identification and makes it HARDER to read!

 

[shift-del]

"Unmerge_CenterAcross" macro
It un-merges the cells and then centres the text horizontally across the cell.

I didn't mean merged cells that are centered but single cells that are centered.
You get that terrible zigzag pattern.

Another bad habit is opening about ten to twenty workbooks on Monday morning and closing them on Friday afternoon - thus leaving them constantly open.
To let someone else edit those workbooks, they are shared.

 

[MARK858]

I didn't mean merged cells that are centered but single cells that are centered.
You get that terrible zigzag pattern.

I am happy now. Something in this thread where I can say well at least my lot don't do that...YET

 

[Atroxell]

Okay, I just remembered another thing. It's not Excel, but it bugs the heck out of me and I watched someone do it (yet again ) yesterday at work.

Why on earth can people not get it through their thick skulls that you do not have to type the desired address into the google search first?

I have seen people go to google, type an address into the search and then click on the link when the results come up. Why not just type it into the address bar?

 

[diddi]

i install the google toolbar for my customers and set startup page to about:blank

i am amazed at the number of people who either type google.com and then when it loads do their search, or complain that they want google as their homepage, so they can wait for it to load exactly the same functionality that is already in the toolbar in front of them.

 

[RobMatthews]

Okay, I just remembered another thing. It's not Excel, but it bugs the heck out of me and I watched someone do it (yet again ) yesterday at work.

Why on earth can people not get it through their thick skulls that you do not have to type the desired address into the google search first?

I have seen people go to google, type an address into the search and then click on the link when the results come up. Why not just type it into the address bar?

We had a vendor doing a sales pitch and displaying his website functionality to the entire engineering team a couple of years ago. To get to *HIS OWN COMPANY'S* website, he typed the company name into google search. And then dithered about which result to click.

I don't think that he works for that company any more.

 

[Michael M]

Yep, you guys are correct in your comments......now go down to the local TAFE and have a look at the "how to use the Internet" classes....Want to find your own company ?...do a google search.
That's what the govt makes us / them teach the users.
I tried to change the study notes and lesson structure some years ago at my TAFE and was very quickly put in my place. It was pointed out that these notes and lessons are compiled by professionals and they are the best they can be !!!

 

[SydneyGeek]

Well... if the notes can't be updated they definitely ARE the best they can be ('cause they will never be otherwise)! Set in stone.

Denis