Clean rows aren’t dangerous, however in most sheets, they’re positively undesirable. Excel makes use of blanks to find out information ranges, and a clean row within the fallacious place will inhibit many built-in options. Thankfully, there’s a simple method to take away clean rows from an information vary, however this straightforward method has the potential to destroy information, so that you have to be cautious.
After deciding on the info vary, proceed as follows:
Press [F5]. Within the ensuing Go To dialog field, click on Particular. Click on the Blanks possibility and click on OK. Doing so selects the clean cells (what you would possibly consider as rows) within the chosen vary. On this case, that is A7:E7 and A10:E10. Now you are able to delete the chosen cells. On the House tab, click on the Delete dropdown within the Cells group and select Delete Cells. Excel will show the Delete dialog field, with the Delete Cells Up possibility chosen. Click on OK. Or, press [Ctrl]+-. Excel will delete the clean cells from the chosen information vary.
Selecting Delete Cells deletes solely the clean cells within the beforehand chosen vary. In case you select Delete Sheet Rows in step four, you possibly can doubtlessly destroy information (typically unseen) to the proper. Select rigorously when utilizing this selection to delete clean rows while you actually wish to delete simply the clean cells. It is simple to suppose by way of rows and select the fallacious possibility!
SEE: 10 Excel time-savers you may not find out about (free PDF) (TechRepublic)
Submit your Microsoft Workplace query
I reply readers’ questions after I can, however there isn’t any assure. Do not ship recordsdata except requested; preliminary requests for assist that arrive with connected recordsdata will likely be deleted unread. You’ll be able to ship screenshots of your information to assist make clear your query. When contacting me, be as particular as potential. For instance, “Please troubleshoot my workbook and repair what’s fallacious” in all probability will not get a response, however “Are you able to inform me why this system is not returning the anticipated outcomes?” would possibly. Please point out the app and model that you just’re utilizing. I am not reimbursed by TechRepublic for my time or experience when serving to readers, nor do I ask for a payment from readers I assist. You’ll be able to contact me at firstname.lastname@example.org.
Editor’s word on Feb. 11, 2019: This Excel tip was first revealed in January 2012. Since then, we’ve added a video tutorial model of the tip and up to date the associated sources.
Microsoft Weekly Publication
Be your organization’s Microsoft insider with the assistance of those Home windows and Workplace tutorials and our consultants’ analyses of Microsoft’s enterprise merchandise.
Delivered Mondays and Wednesdays