General Weirdness
- Two Types Of Security Warnings In Excel 2007
- Excel Gradually Deletes Multiple Extraneous Plus Signs
- Sorting Oddity/Bug
- An Unusual Excel 2007 Help Topic
- How To Screw Up Your AutoFormat Dialog Box
- Options, Options, And More Options
- Who Last Opened That File?
- What Is Truth?
- Click What Button?
- Hijri Dates
- Excel As A Drawing Tool?
- BAHTTEXT?
- Excel Easter Eggs
- How Big Is A Worksheet?
- The 256-Column Limitation
- The Intentional Date Bug
- The DATEDIF Function
- Copying And Pasting A Multiple Selection
- The Camera Tool
- Obscure Shortcut Keys And Mouse Clicks
- Moving Data Validation Messages
- A Range Name Is Really A Named Formula
- A Sheet Named History
VBA Weirdness
- Something Gets Forced
- What Is Truth?
- A Dangerous SpecialCells Bug
- Gaps In The Excel Object Model
- A User-Define Function Can’t Change The Worksheet. Oh Yeah?
- The Elusive Formula1 Property For Conditional Formatting
- XLM Rears Its Ugly Head - -And Crashes Excel
- Makes You Want To Say, “Hmmmmmm….”
- Worse Than A Fatal Error?
- When A Sheet Turns Into A Button
Excel Oddities
Excel is a complex program, and has been around for a long time. Consequently, it has many obscure nooks and crannies to discover. Some of them are described here.
Keep in mind that some versions of Excel are odder than others. In other words, the things described here may not apply to all versions of Excel.
All Odd Stuff
Browse Oddities by Category
Seen Something Odd?
If you've discovered something weird about Excel, let me know.