Excel 2000 in a Nutshell

Excel Menus and Shortcuts

Excel provides a multitude of commands that can be used to design your worksheet. These commands are available from the ten different menus covered extensively in the corresponding chapters within this book. This section provides an overview of these menus and provides some important shortcuts and tasks.

File

The File menu provides the means for dealing with the actual workbook file. This menu contains options for opening, closing, saving, and printing the workbook. Basically, this menu contains all of the options needed to deal with the actual workbook file -- whereas, the other menus provide the commands for manipulating the contents of the workbook.

The first six icons on the Standard toolbar are the most frequently used File menu commands. Although the commands are the same, the Print command on the toolbar and File → Print produce slightly different results. The File → Print option opens the Print dialog where you are able to verify the print settings. The Print command prints the selected print area to the default printer. Another difference exists between the New command on the Standard toolbar and the File → New option. File → New opens a dialog where you can select a template to apply to the new workbook and the New command on the toolbar opens a blank workbook based upon the default workbook settings. For more information about these menu options, refer to Chapter 3.

File Task List

Create a new workbook based upon a template: Chapter 3

Open an ...