Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet. These cells might appear empty but have blank values, some formatting, or a formula.

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.

Deleting an empty row in your data set will also delete out-of-sight data in that row. I’m using Excel 2016 (desktop) on a Windows 10 64-bit system.