How To Delete Cells, Rows, Columns and Spreadsheets in an Excel Workbook?

Posted on

In a previous post of mine, I had mentioned How To Insert Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook. What happens though, when we come to a point that we want to Delete Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook. All you need to do is to continue reading this post.

How To Delete Cells, Rows, Columns & Sheets in Excel

For us to Delete Cells in a Spreadsheet, we must select the area of Cells that we need to Delete as shown in the image below. The number of Cells selected, the same amount will be Deleted in our Spreadsheet.

Styles Area on Home Tab in Excel

Once the area of Cells is selected, there are two ways to Delete Cells. The first one, is to do a right click with our mouse on top of the selected area, and then from the shortcut menu that appears, we select the command Delete as shown below.

Delete Cells

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete and from the drop-down menu we select the command Delete Cells.

Delete Cells

Whatever way we choose, the same dialog box will appear which is named Delete, where we have the following options to choose from:

  • Shift Cells Left
  • Shift Cells Up
  • Entire Row
  • Entire Column

Delete Cells Dialog Box

For us to Delete Rows in a Spreadsheet, we must select the number of Rows that we want to Delete. When we Delete Rows, the same number of Rows selected will be Deleted and the ones below will move up, depending on how many Rows where selected. The first way to Delete Rows, is to do a right click with our mouse on top of the selected Rows and then from the shortcut menu that appears we select the command Delete.

Delete Rows

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete and from the drop-down menu we select the command Delete Sheet Rows. As mentioned above, the same number of selected Rows will be Deleted.

Delete Sheet Rows

For us to Delete Columns in a Spreadsheet, we must select the number of Columns that we want to Delete. When we Delete Columns, the same number of Columns selected will be Deleted and the ones at the right will move left, depending on how many Columns where selected. The first way to Delete Columns, is to do a right click with our mouse on top of the selected Columns and then from the shortcut menu that appears we select the command Delete.

Delete Columns

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete and from the drop-down menu we select the command Delete Sheet Columns. As mentioned above, the same number of selected Columns will be Deleted.

Delete Sheet Columns

For us to Delete a Spreadsheet in our Workbook, the first way is to move on top of a Sheet that already exists in our Workbook, and then do a right click with our mouse. From the shortcut menu that appears we select the command Delete as shown in the image below. If the Spreadsheet doesn’t contain any data, the Spreadsheet will be deleted straight away without any warning. If the Spreadsheet contains data, a warning dialog box will appear asking for our confirmation.

Delete Sheet

The second way is from the Home tab, we locate the area named Cells of the ribbon as shown below and then we select the command Delete Sheet and from the drop-down menu we select the command Delete Sheet. As mentioned above, if the Spreadsheet doesn’t contain any data, the Spreadsheet will be deleted straight away without any warning. If the Spreadsheet contains data, a warning dialog box will appear asking for our confirmation.

Delete Sheet

Below you can check out the video describing How To Delete Cells, Rows, Columns and Spreadsheets in an Excel Workbook.

Don’t Forget to Subscribe To My YouTube Channel.

YouTube Channel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s