Two methods will be listed here for you to delete blank rows or columns that you want to remove from excel data. How to delete blank rows/columns in Excel? Instantly, all of the found cells would be removed or deleted from data range. Step 3: In results you find, press Ctrl + A to select all of them and click “ Delete > Delete Sheet Rows” in Home tab and Cells group. Click Find All and all the blank cells are found. Under Find tab in Find and Replace dialog, click the Options to expand all the options you can set when you want to find something in selected excel file.įor example, if you want to find out all the blank cells in selected data range, choose to Look in “ Values” and let Find what be blank. Step 2: In Home tab, press Ctrl + F to open Find and Replace dialog. Step 1: Select the data range you want to delete blank cells. So let’s learn to delete or remove blank or empty cells/rows/columns easily, even though it would probably damage your excel data. But if the excel file is large, and there are several excel spreadsheets in it, probably manual deletion would waste you lots of time. If there are some blank cells, rows, or columns that make your excel data seems not so easy to read or edit, you can try to delete or move them manually and accurately.
