Just a place where I can write all the things I hate about Excel. Remember to just breathe
me@jaykilleen.com wrote this over 7 years ago and it was last updated over 6 years ago.
This is just my blog therapy. A place where I can store things that annoy me about Excel and potentially some shortcuts to overcome these annoyances.
If this is your guilty pleasure, please enjoy my rantings.
You can also read How Much #ExcelSucks on Twitter
I just want Excel to scroll like any other program like Chrome. When I open Excel I feel like disjointed and broken like try-ing-to-speak-one-sy-lla-ble-at-a-time. https://stackoverflow.com/questions/7200000/can-i-make-excel-scroll-smoothly-without-using-middle-click
There is nothing more frustrating in Excel than making a change to a table and then returning to see a whole lot of #REF! errors inside of your formulas. Stop touching my stuff Excel!! Gosh!
#REF!
#REF!
#REF!
#REF!
#REF!
How about just leaving my formula the f alone and returning an error as the result of the formula. That way when I look at my formula I can see something like User[email]
and think Oh thats cause I renamed that to User[mail]
and thus I need to make that change ... ... instead I see #REF!
like try and rebuild your burnt down house without looking at any plans you imbecile LOL Oh damn #Excel Sucks
This Tweet from Bill Jelen pointing to a post from Contextures about the 255 character limit that Excel has when using the COUNTIF formula.