Excel Keyboard Shortcuts – Deleting

Did you know that you can delete a row or column in Excel using a sequence of keyboard strokes rather than having to reach for the mouse?

Keyboard Shortcuts

  1. Delete a Column
  2. Delete a Row
  3. Delete a Cell
  4. Delete Cell Contents
  5. Other Excel Keyboard Contents

Key

or * = Hold this key down while tapping the white keys in sequence indicated.

= Tap this key(s) in sequence indicated (if there is more than one) whilst holding down the grey key.

Delete Column

ALT* + E
+ D + C


Using ALT Keyboard shortcuts
Excel Keyboard Shortcut Delete Excel Keyboard Shortcut Column

Starting Position
After ALT* + E + D + C

Delete Row

ALT* + E
+ D + R


Using ALT Keyboard shortcuts
Excel Keyboard Shortcut Delete Excel Keyboard Shortcut Insert a Row

Starting Position
After ALT* + E + D + R

Delete Cell

ALT* + E
+ D + E


Using ALT Keyboard shortcuts
Excel Keyboard Shortcut Delete Excel Keyboard Shortcut Cell

Starting Position
After ALT* + E + D + E

Clear Cell Contents

DELETE


Excel Keyboard Shortcut Clear Contents

Starting Position
After DELETE*

Other Excel Keyboard Shortcuts

  1. Navigation
  2. Selection
  3. Inserting
  4. Values
  5. Std Office Shortcuts

Other Excel Spreadsheet Help

Follow our blog on Excel Tips and General Business Data Advice.

Our Business Spreadsheets page has some complementary spreadsheet downloads which walk you through everyday office spreadsheet tasks.

Comments are closed.