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.
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.
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…
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.
Straight away, the empty Cells, Rows and Columns are highlighted as shown below.
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.
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.
Posted on October 5, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged Blanks, Cells, Delete Blank Rows and Columns in Excel 13, Delete Sheet Columns, Delete Sheet Rows, Find & Select, Go To Special, Microsoft Excel 13, Microsoft Office 13, MVP, Office Smart, Office System, Rows, Smart Office. Bookmark the permalink. Comments Off on Delete Multiple Blank Rows and Columns in Excel 13.