Inserting and Deleting Cells


Inserting and Deleting Cells

To change the contents and layout of your worksheets, you ll often need to insert extra cells or delete existing cells. Excel provides keyboard shortcuts for both operations.

Shortcuts for Inserting and Deleting Cells

Delete the selected cells

[Ctrl] - [-]

If you have one or more cells selected, Excel displays the Delete cells dialog box (shown here) so that you can specify in which direction to move the remaining cells. You can also choose to delete the row or column. If you press this shortcut with one or more rows or columns selected, Excel deletes the rows or columns without confirmation.

Insert cells

[Ctrl] - [Shift] - [+]

Excel displays the Insert cells dialog box (shown here) so that you can choose whether to move the other cells to the right or down. You can also choose to insert an entire row or column. If you press this shortcut with one or more rows or columns selected, Excel inserts the same number of rows or columns without displaying the Insert cells dialog box.




Windows XP and Office 2003 Keyboard Shortcuts
Windows XP and Office 2003 Keyboard Shortcuts
ISBN: 0072255005
EAN: 2147483647
Year: 2003
Pages: 117

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net