Now choose the Delete Sheet Rows option under the Delete drop down box. In the Go to Special dialogue box, choose Blanks and hit OK. Here navigate to the Editing options and choose the Go To Special option under the Find & Select option. Please note that this tip applies to removing multiple columns as well.įirst select the portion of the spreadsheet from where you wish to remove the blank rows and then hit the Home tab. Here is a small tip for those using Excel 2010 who want to remove all blank rows in an easy way without having to remove each blank row manually. ![]() ![]() Advertising, Partnership, & Sponsorships.
0 Comments
Leave a Reply. |