T. Valko
Well-known Member
- Joined
- May 9, 2009
- Messages
- 16,623
AMEN, brother!
Excel IS NOT an electronic coloring book for adults.
I absolutely loathe long sheet/file names.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Do you have any Excel OCD habits?
- Thread starter MrKowz
- Start date
Excel IS NOT an electronic coloring book for adults.
I absolutely loathe long sheet/file names.
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,898
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
OH Yeah !!
Long file names AND repetition
An employee downloaded a folder to my server to take a look at his data.
A day for each !!! OMG !!!
RoadsData revision version 1 dated Friday 010110.xls
RoadsData revision version 2 dated Monday 040110.xls
RoadsData revision version 3 dated Tuesday 050110.xls
etc,etc,etc.
Long file names AND repetition
An employee downloaded a folder to my server to take a look at his data.
A day for each !!! OMG !!!
RoadsData revision version 1 dated Friday 010110.xls
RoadsData revision version 2 dated Monday 040110.xls
RoadsData revision version 3 dated Tuesday 050110.xls
etc,etc,etc.
Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,912
- Office Version
- 365
- Platform
- Windows
Haven't seen you around the board for a while. Welcome back!
I hate it when people create lists in hidden columns beside their summaries. By lists I mean for list validation. I believe the lists should be transparent in a separate sheet.
Domski
Well-known Member
- Joined
- Jan 18, 2005
- Messages
- 7,292
What's the fun in that? At least format them ;;; to make the hunt a little bit interesting
Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,912
- Office Version
- 365
- Platform
- Windows
Ooooh I hate that. Workings that are given the same font colour as the fill colour.
cornflakegirl
Well-known Member
- Joined
- Nov 4, 2004
- Messages
- 2,023
I hate values that are centred - much harder to compare them!
I also tend to end up with quite long file names - I'm modelling business cases that go through several revisions, so tend to use the business case name, plus the main change that's been done, plus the date, to give us a fighting chance of working out which of the seven versions is the right one to look at.
cornflakegirl
Well-known Member
- Joined
- Nov 4, 2004
- Messages
- 2,023
Actually, there's one thing that I do that I hate (or at least think is pretty rubbish). I'm a big fan of data tables for displaying the results of High/Medium/Low scenarios for example, but I often want to show just the results part, and not the top row or leftmost column that drive the table (because they can be confusing for users who don't understand how the tables work). But since the tables have to be on the same sheet as the High/Medium/Low dropdown cell that drives them, I resort to hiding the extraneous bits. It's a messy solution that I don't like at all!
crook_101
Well-known Member
- Joined
- Oct 20, 2008
- Messages
- 687
Formatting, formatting and probably my biggest bugbear is "expert excel users in the Company"
Formatting 1 - colours burning eyes, previously mention I known, just thought that I would re-ignite this baby
Formatting 2 - Merged/hidden cells - if you are have a problem with your sheet and want me to look at it, i need to see all of it
Merged cellls - spot one and run my unmerge all macro - this is such a pleasing thing, gives me a little warm feeling inside every time I use it
"expert excel users in the Company" - my blood pressure is rising already!! There are some people that really shouldn't have user rights for excel, they should be limited to paper and blunt crayons
/rant over
Formatting 1 - colours burning eyes, previously mention I known, just thought that I would re-ignite this baby
Formatting 2 - Merged/hidden cells - if you are have a problem with your sheet and want me to look at it, i need to see all of it
Merged cellls - spot one and run my unmerge all macro - this is such a pleasing thing, gives me a little warm feeling inside every time I use it"expert excel users in the Company" - my blood pressure is rising already!! There are some people that really shouldn't have user rights for excel, they should be limited to paper and blunt crayons
/rant over
