Home Computer Repair How To Delete All Blank Columns in Microsoft Excel

How To Delete All Blank Columns in Microsoft Excel

190

There are multiple ways to delete blank columns in a Microsoft Excel file. Why would you need to do this? – Simple.

Every now and then, the data that you import from webpages may result in a great number of columns appearing even if they’re not used. You see this happening with CSV files and .txt files just as often.

When it happens, deleting columns manually may not always be easy. Sure, if you only have two or three empty columns, it’s quite ok to delete them manually. But what if your imported project creates 57 empty and non-continuous columns? – For that, you’ll need an automated process.