Page 44 - Microsoft Office Excel 2003 Programming Inside Out

Part 1: Preliminaries
Microsoft Office Excel 2003 Programming Inside Out

You can have Excel show which cells comprise a named range by clicking the down arrow at
the right edge of the Name box and clicking the name of the range you want to see.

The Excel Interface
Having a powerful spreadsheet program at your fingertips doesn’t do you any good if you’re
not able to find what you’re looking for, so the Excel designers spent a lot of time working on
the organization and appearance of the Excel interface to make it easier for users to get the
most out of their workbooks. Figure 2-4 shows the Excel window in all its glory, with callouts
for the elements most commonly used in using and programming Excel.

Inside Out
Chapter 2
Starting with Excel 2002, the program came with an adaptive menu system that just dis­
played the most basic commands, requiring you to hover the mouse pointer over the bottom
of a menu to expand the menu. It’s a great idea in theory, but for most users, who don’t
have thorough knowledge of the program, it’s quite a hindrance. You can, and should, turn
off the adaptive menu system by clicking Tools, Customize, Always Show Full Menus.

Figure 2-4. The Excel interface offers quick access to the program’s diverse capabilities.

18