SLNC logo
SPECIAL LEARNING NEEDS CONSULTANT
...Making learning and technology easy, accessible, affordable and available for everyone

A QUICK WAY TO CLEAR OR DELETE MICROSOFT EXCEL DATA


Olufemi S.A. Bayode on January 15, 2019 with 11 comments

Clearing and deleting data entry are regarded as ways of amending worksheets. They facilitate removal of wrongly inputted or inserted data in a worksheet. This therefore, allows the entry of correct and appropriate data into the worksheet.


When you clear a data entry in a cell, column, row or sheet, the entire data including values, text, symbols, comments and formulae are removed but the row or column remains in the place blank. In contrast, when you delete a row, column or a sheet, the entire data is removed as well as sheet, the column or row. The “delete” action also close up the blank space that would have been created by mere clearing. Hence, there won’t be need to cut other entry from the same Worksheet to fill up the blank space or racking your brain for the keystroke to remove row or column in a Worksheet.


Clearing

  1. Move to the sheet, column or row to be cleared in the workbook.
  2. Highlight with the correct and appropriate keystroke e.g. CONTROL+A for sheet, CONTROL+SPACE BAR key for column, and SHIFT+SPACE BAR key for row.
  3. Press the DELETE key.

This wipes the highlighted data entry in the Worksheet without closing up the cleared region with the next data entry. The only option to close up the blank space is to fill it via typing or copy and paste.


Deleting

  1. Move to the region of the unwanted data entry in the Worksheet.
  2. Highlight the cell, row, column or range you wish to remove with the appropriate keystroke. E.g. SHIFT+SPACE BAR for row while CONTROL+SPACE BAR is for column.
  3. Press the keystroke CONTROL+- “minus” for the removal.

This removes every data entry and cells along the highlighted row or column and fill up the gap or blank space that would have been created if the DELETE key was used. Should you want a blank cell, row or column at the same spot, press the keystroke CONTROL++ “plus” for the operation. To delete Worksheet from a Workbook:

  1. Navigate to the sheet with the keystroke CONTROL+PAGE UP or CONTROL+PAGE DOWN.
  2. Press the keystroke ALT+E, then L.
  3. Press the ENTER key to activate the “Delete” button.

Please note, if you accidentally clear or delete the wrong column, row or cell, you can undo your action by pressing the keystroke CONTROL+Z. In case of the removal of a Worksheet, you cannot undo your action. The only option you have is to close the Workbook without saving the change. This returns the Worksheet to the Workbook.