![]() Now click Find & Select and choose Go To Special. Then make sure you are on the Home tab of the ribbon. To start off, select the entire first column. So let's look at a really fast way to do it using Excel's Go To Special command. But that will take a really long time, and it won't be any fun at all. Sure, we could just work our way through the list, deleting these empty rows one by one. If we hop down to the bottom of the sheet, then back up to the bottom row, we can see that we have over 36,000 rows, and several thousand of these rows are empty. ![]() Here we have a really big list that contains a lot of empty rows. Even better, Excel does all the hard work for you. In today's ExcelJet tip, we'll show you a cool way to delete blank rows, even hundreds or thousands of blank rows, in record time. You could delete the rows one by one, but that's going to take a long time, especially if you have lots of blank rows. ![]() Sometimes you have a large list that contains empty rows, and you need to remove these rows in order to clean up the list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |