We can use filters in a slightly different way to get rid of the blank rows. When we clear the filters, all our data will still be there but without the blank rows! We can then press the OK button when Excel asks us if we want to Delete entire sheet row. #Excel how many rows selected manual#We can now select these blank rows with the blue row numbering and delete them using any of the manual methods. When our data is filtered, the row numbers appear in blue and filtered rows are numbers are missing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |