![]() Please Note: You need to be careful about one thing, if there are any missing values in any column they also get deleted and the displaced data can cause inconsistency. And, the entire unfilled rows will be deleted.Move to Home > Delete > Delete Sheet Rows without clicking anywhere on the sheet (otherwise your selection will be removed).This will select all the blank cells immediately and you need to delete them. ![]() Now, in the Go To Special dialog box, click the ‘Blanks’ radio button and OK.Navigate to Home > Find & Select > Go To Special. ![]()
0 Comments
Leave a Reply. |