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 > pressCtrl + Fkeys to open theFind 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 > pressCtrl + Afor selecting the entire blank cells. 5. Close the dialog box of“Find and Replace” and without clicking anywhere else goto 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.2KViews0likes0Comments