Delete Multiple Blank Rows and Columns in Excel 13

Usually when we have a Worksheet containing a lot of data, we find ourselves to have a lot of empty Rows or Columns in it. What happens if we want to delete these empty Rows or Columns. We can delete the empty Columns or Rows, just by right clicking on the selected Column or Rows and from the shortcut menu that appears we just select the command Delete as shown in the image below. What though if we want to delete multiple empty Columns or Rows?

All we have to do is to follow the steps described below.

Right Click - Delete

First we must select the area that contains the data among with the empty Cells and Rows as we can see in the image below.

Select Area

Then from the Home tab we locate the area named Edit and then select the command Find & Select as shown below. From the drop down menu that appears we select the command Go To Special…

Go To Special

Once the command Go To Special is selected, the Go To Special dialog box appears. In this dialog box we activate the check box next to the command Blanks as we can see in the image below. Then we just select the OK button in order for the command to take place.

Go To Special- Blanks

Straight away, the empty Cells, Rows and Columns are highlighted as shown below.

Selected Area

Then from the Home tab we find the area of the ribbon named Cells and select the command Delete as shown below. The drop down menu appears as shown below where we just select the command Delete Sheet Rows.

Delete Sheet Rows

That is it! All the empty Rows are deleted from the Worksheet. The same procedure is followed for deleting empty Columns. We follow the steps described above and at the end we select the command Delete Sheet Columns.

By following these steps in order to delete blank Rows and Columns is much faster than by deleting them one by one, especially if we have a large Worksheet.

Below you can check out the video describing how to Delete Multiple Empty Rows or Columns in Excel 13.


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 October 5, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Delete Multiple Blank Rows and Columns in Excel 13.

Comments are closed.