Oddities, Weirdness, Minutia, etc...
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.
General Weirdness:
- How to screw up your AutoFormat dialog box
- Options, options, and more options
- A stacked radar chart?
- Who last opened that file?
- What is truth?
- Click what button?
- Hijri Dates
- Excel as a drawing tool?
- BAHTTEXT?
- Easter eggs
- How big is a worksheet?
- The 256-column limitation
- The intentional date bug
- The DATEDIF worksheet function
- Copying and pasting a multiple selection
- The "camera" tool
- Obscure shortcut keys and mouse clicks
- Moving data validation messages
- A named range is really a named formula
- A sheet named History
VBA Weirdness:
- A dangerous SpecialCells bug
- Gaps in the Excel object model
- A user-defined function can't change the worksheet. Or can it?
- The elusive Formula1 property for conditional formatting
- XLM rears its ugly head -- and crashes Excel
- Makes you want to say, "Hmmmmm..."
- Is this worse than a fatal error?
- Pasting a bitmap to a UserForm control
- When a sheet turns into a button
This list, of course, barely scratches the surface.
Have you discovered an Excel oddity? If so, contribute it.