edwards142
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: delete a row in an excel file
I have some simple fixes using which you can easily delete blank rows in Excel. 1. Choose the data set > press Ctrl + F keys to open the Find and Replace dialog. 2. Hit the “Options” button > choose “Values” from “Look in” And let the “Find What” text box blank > click “Find All”. 3. Dialog box of “Find and Replace” will highlight entire blank cells. 4. Click any one record > press Ctrl + A for selecting the entire blank cells. 5. Close the dialog box of “Find and Replace” and without clicking anywhere else go to Home > Delete > Delete Rows. 6. Doing this will delete the entire selected rows. For more tricks like this, check out this link. source: www.repairmsexcel.com/blog/delete-blank-rows-in-excel1.3KViews0likes0Comments