Select the Options button and check the box for Match entire cell contents.You wouldn’t want to delete an entire row and lose those cells with data. Note: Avoid this method on sheets where only a few cells are empty instead of entire rows. You can also use the Ctrl + F keyboard shortcut to bring up the Find and Replace dialog box. Use it to find all empty rows in a sheet or the entire workbook and then delete them in one go. The Find and Replace command is under the Find & Select button on the Home tab. But it gets cumbersome if you have to scroll around to find and then select multiple blank rows. Using the simple delete command is enough when you just have a few blank rows in your spreadsheet. Use the Find command to search and remove blank rows in Excel Re-sort the data according to this index column and then delete it.
0 Comments
Leave a Reply. |