Contents

Know more about this
(or any other) subject?

Show off your know-how at Quamut Wiki.

Learn more with these titles from Barnes & Noble

Previous:
Shortcuts for Copying and Moving Text and Data

Next:
Shortcuts for Formatting Cells and Text

Shortcuts for Inserting and Deleting Cells, Text, Data, and Graphics

Inserting and Deleting Cell Data, Rows, and Columns

Action		Keyboard Shortcut
Delete the contents of an active cell		Delete or Backspace
Delete one character to the left		Double-click the cell (or press F2), then press the Backspace key
Delete one character to the right		Double-click the cell (or press F2), then press the Delete key
Open the Delete dialog box (for deleting cells, rows, or columns)		Ctrl+Minus Sign
Open the Insert dialog box (for inserting cells, rows, or columns)		Ctrl+Shift+Plus Sign

Action		Keyboard Shortcut
Open the Create Table dialog box to add a table to the current worksheet		Ctrl+T
Insert a chart into the current worksheet based on selected cells		Alt+F1
Insert a chart in a new worksheet		F11
Add a picture to the current worksheet		Alt+N, P
Add clip art to the current worksheet		Alt+N, F
Add a shape to the current worksheet		Alt+N, SH
Add Smart Art (such as a flowchart) to the current worksheet		Alt+N, M
Show or hide a selected object, such as a chart or photo		Ctrl+6

Previous:
Shortcuts for Copying and Moving Text and Data

Next:
Shortcuts for Formatting Cells and Text

Download the PDF
for just $2.95

► Complete guide
► Handy, portable format