DELETE BLANK COLUMNS IN EXCEL 2016 HOW TO

This is an easy way to delete blank cells without accidentally deleting data. Ensure that Shift Cells Up is selected, and click OK.Įxcel will now delete all the blank cells and shift the other cells up, so that there are no blanks and so that order is maintained. Right click on any one of the highlighted cells and select Delete.ĥ. You will note that Excel now highlights all the blank cells.Ĥ.

On the Home Ribbon, under the Editing tab, click on Find and Select, and then Go To Special from the drop-down list. Highlight the cells with the data and blank cells in the worksheet.Ģ. To delete the blank cells and move all other data up, follow these steps:ġ. You are welcome to download the workbook to practice.Īs you can see above, partial data has been removed leaving blank spaces in between the data. The software can fix all types of Excel errors and restore all tables, charts, cell comments, images, formulas, sorts, and filters to a. In this case, repair the Excel workbook by using Stellar Repair for Excel software.

DELETE BLANK COLUMNS IN EXCEL 2016 HOW TO

In this tip, we explain how to remove blank cells between your data in Excel so that this happens.Īpplies To: Microsoft ® Excel ® for Windows 2010, 2013, and 2016. If the Excel 2016 opens blank screen problem persists, the Excel workbook you’re trying to open might be severely damaged. Every now and then, the data that you import from webpages may result in a great. As you work through a spreadsheet, you may delete a number of cells and then want Excel to shift all the cells up again so that there are no blanks. There are multiple ways to delete blank columns in a Microsoft Excel file.

Delete blank columns in excel 2016