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

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

Advertisements

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 11, 2019, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on How To Delete Cells, Rows, Columns and Spreadsheets in an Excel Workbook?.

Comments are closed.