In the above table, we can see some blank rows. How To Get Rid of Extra Blank Rows Within The Table? ![]() ![]() Learn 50 Excel Shortcuts to Increase Your Productivity. Now press CTRL+ - (CTRL and Minus) key combination. This will select the entire row of selected cells. Now press the CTRL+SHIFT+SPACE key combination. Keep this combination pressed until you reach the last row in the sheet. To do so, I select the 13th row and press CTRL+SHIFT +DOWN Arrow key. The rows below the 12th row are unused and I would like to delete these rows and the data if they contain any. How To Delete Extra Blank Rows From Sheets? Delete Unused Rows So That They Don't Show (Hide Them). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |