Delete Worksheet Rows & Columns in Excel

Question

How to delete worksheet rows and columns in Excel?

Answer

To delete cells, rows, or columns, select the Home tab, then from the Cells group select Insert or Delete. 

You can also or right click on a heading or a selection of cells and choose Delete from the shortcut menu.

Clearing, as opposed to deleting, does not alter the structure of the worksheet or shift un-cleared data cells. When you want to clear a cell or range of cells, choose Clear from the Editing group in the Home tab.

What can be confusing about this process is that you can use the Delete key to clear cells, but it does not remove them from the worksheet as you might expect.

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.