Microsoft Office Tutorials and References
In Depth Information
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.
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.
The Excel interface offers quick access to the program’s diverse capabilities.