Microsoft Office Tutorials and References
In Depth Information
You can use Ctrl+* (asterisk) to select an entire table. And when a large range is selected, you can use Ctrl+.
(period) to move among the four corners of the range.
Clicking an object placed on the drawing layer selects the object. An exception occurs if the object has a macro
assigned to it. In such a case, clicking the object executes the macro. To select multiple objects or noncontigu-
ous cells, press Ctrl while you select the objects or cells.
Changing your mind
You can reverse almost every action in Excel by using the Undo command, located on the Quick Access toolbar.
Click Undo (or press Ctrl+Z) after issuing a command in error, and it's as if you never issued the command. You
can reverse the effects of the past 100 actions that you performed by executing Undo more than once.
Click the arrow on the right side of the Undo button to see a list of the actions that you can reverse. Click an item
in that list to undo that action and all the subsequent actions you performed.
You can't reverse every action, however. Generally, anything that you do using the File button can't be undone.
For example, if you save a file and realize that you've overwritten a good copy with a bad one, Undo can't save
the day. You're just out of luck unless you have a backup of the file. Also, changes made by a macro cannot be
undone. In fact, executing a macro that changes the workbook clears the Undo list.
The Redo button, also on the Quick Access toolbar, performs the opposite of the Undo button: Redo reissues
commands that have been undone. If nothing has been undone, this command is not available.
The Excel Help System
One of Excel's most important features is its Help system. The Help icon (a question mark), is located near the
upper-right corner of the Excel window. Clicking the Help icon or pressing the F1 function key displays the
Help system window. Figure 1-6 shows an example.
By default, the content shown is downloaded from the Microsoft Office website. If you do not have Internet ac-
cess or you prefer to limit Help to articles on your computer, click the arrow to the right of the title of the Help
window and choose Excel Help from Your Computer.
Excel provides two types of cell formatting — numeric formatting and stylistic formatting.
Numeric formatting refers to how a value appears in the cell. In addition to choosing from an extensive list of
predefined formats, you can create your own custom number formats in the Number tab of the Format Cells dia-
log box. (Choose the dialog box launcher at the bottom of the Home ⇒ Number group.)