Excel Hacks Ebook [Electronic resources]

Windows and Macintosh Users

The hacks in this book were written for Windows versions of Excel and were tested on a Macintosh using Excel.X. Most of the differences between the two platform versions are cosmetic, and most involve changes to key combinations and the occasional menu. Where the key combinations differ, they are written with the Windows modifier first, as in Alt/Command()-Q, which means Alt-Q for Windows and -Q on the Macintosh. There are a few cases, especially in the Visual Basic Editor (VBE), where the interfaces look different and have different menu choices, and these are explained on first encounter. There also are a few Windows-only hacks, using the Windows registry and other features that are supported only on Windows versions of Excel. These are noted in the text.

Macintosh users with one-button mice should also note that holding down the Control key while clicking is the equivalent of right-clicking. (Macintosh users with two or more buttons can just right-click.)

Most of the hacks should work with any version of Excel from Excel 97 onward; the text will indicate when this isn't the case. Screenshots were taken using a variety of different versions of Excel and are not an indicator of which hacks work with which versions.