![]() ![]() What if there are many blank rows spread across our data? Manual selection would be a pain!ĭon’t worry, there is a command in Excel to select all the blank cells for us.įirst, we need to select a column of our data including all the blank rows. Selecting and deleting rows manually is OK if we only have a couple rows to delete. There is also a very handy keyboard shortcut to delete rows (columns or cells). Go to the Home tab ➜ click on the Delete command ➜ then choose Delete Sheet Rows. We can also delete rows using a ribbon command. When the rows we want to delete are selected then we can right click and choose Delete from the menu. Hold Ctrl key and click on a row to select it. ![]() But if we only have a couple rows then the manual way can be quicker. Delete Blank Rows Using The Filter Functionĭon’t worry, we’ll get to the easier methods after.Delete Blank Rows Using Advanced Filters. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |