You can see a "Special" button at the bottom left corner. Now press CTRL+G combination to open the Go-To dialog. I select the D column in Table because if there is no volume of the keyword, that row is useless to me. Select the entire main column by which you want to delete blank rows. You can delete unused rows in one go.įollow these steps to delete all unused rows from the data table: In such cases deleting blank rows can be a major issue. In real data you may have thousands of rows with hundreds of random unused rows. In this example, we have only 2 blank rows, which can be deleted manually. In the above table, we can see some blank rows.
DELETING ACROSS ROWS ON EXCEL FOR MAC HOW TO
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?
0 kommentar(er)
