Delete Blank Rows using GoTo Special in Excel

In this article, we’ll get to know how to delete blank rows using GoTo special option in Microsoft Excel.

The GoTo special option is one of the Find & Select options. Its function is to go to the cell which satisfies the particular command that has been selected.

How to delete using GoTo Special option in Excel?

First, select the range of cells in which you want to act.

Then go to Find & Select option under the Editing group in the Home menu.

Delete Blank Rows using GoTo Special in Excel

Then select GoTo special, and select the Blanks option in the dialogue box that opens up.

Delete Blank Rows using GoTo Special in Excel

Now the blank cells will be selected.

Delete Blank Rows using GoTo Special in Excel

Now select the Delete option in the Cells group in the Home menu.

Under the delete option select the Delete Sheet Rows option.

Delete Blank Rows using GoTo Special in Excel

Now you can view the changes you’ve made.

Delete Blank Rows using GoTo Special in Excel

This is how you delete Blank rows using GoTo special option in Microsoft Excel.

    1 Comment

  1. User Avatar
    April 14, 2023
    Reply

    Well, I doubted whether it will work or not but it works

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021