![]() Step 3: Choose the radio button corresponding to Blanks and hit the OK button. Step 2: In the Go To window, click on the button named Special. As next, towards the right corner of the window, find and click on the Binocular icon for Find and Select and choose Go To from the dropdown menu. Step 1: Firstly, make sure you are at the HOME tab of your excel sheet. But today, we are going to use it to hunt down the blank rows in your excel and to delete them all at once. The Go To Special feature is useful for many purposes. That’s it, all of the selected rows would now be deleted. Once all the rows to be deleted are selected, simply right click and click on the Delete option. You can even select other unwanted rows, they need not be blank to be deleted. Keep the CTRL key pressed and c lick on the heads of the blank rows that you want to delete. To manually delete the blank rows, firstly, hold down the CTRL key. But if there are only a couple of blank rows to be deleted, then manual deletion sure is something you can consider. We know no one like anything manual and that it’s all automation these days. Solution 1: By Manually Selecting and Deleting Blank Rows ![]() Solution 5: Using Find and Replace Functionality.Solution 2: Using Go To Special Feature. ![]() Solution 1: By Manually Selecting and Deleting Blank Rows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |