Page 338 - Excel Workbook for Dummies

38_798452 ch27.qxp 3/13/06 8:00 PM Page 321

Chapter 27

Ten (More or Less) Shortcut Keys

forEditing Data

orksheet editing forms a significant part of the work you do in Excel. For that reason,
Wthe editing shortcut keys presented in Table 27-1 can go a long way to making your
editing work much more efficient. Of all the key combinations in this category, I urge you
to become familiar with Ctrl+hyphen (-) to open the Delete dialog box and Ctrl+Shift+plus
sign (+) to open the Insert dialog box. The Delete dialog box enables you to remove cells
and their contents from tables and lists in the worksheet, while at the same time adjusting
the remaining cells in the table or list so that there are no gaps in the data. The Insert dialog
box enables you to insert new cells in tables and lists, while at the same time adjusting the
remaining cells in the table or list so that they are overwritten.

Table 27-1 Editing Shortcut Keys

Press To
F2 Edit current cell entry and position insertion point at the end of cell contents
Shift+F2 Edit comment attached to current cell and position insertion point in
comment box
Backspace Delete character to left of insertion point when editing cell entry
Delete Delete character to right of insertion point when editing cell entry:
otherwise, clear cell entries in current range

Esc Cancel editing in current cell entry
Enter Complete editing in current cell entry
Ctrl+CC Open Clipboard Task pane
Ctrl+C Copy cell selection to the Windows Clipboard

Ctrl+X Cut cell selection to the Windows Clipboard
Ctrl+V Paste last copied or cut cells from the Windows Clipboard
Ctrl+hyphen (-) Open Delete dialog box to delete cell selection and shift remaining cells left
or up

Ctrl+Shift+plus (+) Open Insert dialog box to insert new cells and shift existing cells right
or down
Ctrl+Z Undo last action

Ctrl+Y Redo last action