Select "Delete Sheet" to remove the current worksheet. Hide a worksheet that you're not sure you want to delete. Switch to the "Home" tab of the Excel ribbon and locate its Cells group.

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.

Click the "Home" tab again, navigate to the "Cells" section, and click "Delete Sheet Rows" from the drop-down menu. You can repeat a similar process to remove blank columns from your spreadsheet.

Excel uses blanks to determine ranges, so its selection-based features won’t work as expected if there are blank rows anywhere in your data set.

How to Remove Leading Blank Spaces in Excel. However carefully you monitor the data you enter and import into Microsoft Excel, and the output of formulas and functions that produce new values, it ...