Sometimes, while filling up the large list, empty rows remain at the end of the process. To make your work look like a flawless job, you need to clean up the list. Removing blank cells in rows or columns from Microsoft Excel individually can be a laborious task. Find a solution to this problem in our tutorial.
Excel 365 and Microsoft Excel offer many new and improved features, and users of the most recent versions of Excel will find nothing to scare them off. Most of them offer the ability to create, open, edit, and save files in the cloud straight from the desktop.
Remove Blank Cells from Excel spreadsheet
In the Excel spreadsheet screenshot shown, a workbook with data in multiple columns is visible. Between each you can notice column, these are blank cells. I am interested in having these blank cells removed. To do so, do the following,
Highlight just the range of data containing the blank cells.
Next, under the Home tab > Editing group click ‘Find & Select’ option.
Now, with your spreadsheet open, press F5 on the keyboard. The action instantly opens up ‘Go To’ window,
When seen, click Go To Special option.
Choose the Blanks radio box and click OK.
You’ll see that Excel made a non-adjacent selection of all the blank cells in the spreadsheet. This makes it easy to delete the cells you don’t want.
After having done this, from the Home tab, under the Cells group, click Delete and then select whether you want to delete the blank cells in rows or columns. In my case, it was just empty columns.
That’s it! Your Excel spreadsheet gets the look you wished to impart and looks a lot better.
Please note that the method can be used to delete blank rows and columns quickly if you have a large workbook containing large and multiple worksheets.
Read: Unable to change date format in Excel
How do you get rid of blank cells in Excel?
To get rid of or delete blank cells in the Excel spreadsheet, you need to follow the above-mentioned guide. You need to go to Find & Select option and click on the Go To tab. Then, click on the Go To Special option and select the Blanks option. Click the OK button and group all blank cells. Then, click the Delete button to remove all the empty cells at once.
How do you remove thousands of blank columns in Excel?
Removing blank cells and columns in an Excel spreadsheet is not that different. You need to follow the same guide as mentioned above to get rid of blank columns from the Excel file. For your information, you need to use the Find & Select panel to get the job done.
“In my case, it was just empty columns.” I’m a bit confused. What I’m seeing looks like empty rows, not columns.