how to delete blank columns in excel spreadsheet

However, if you’re not familiar with macros, this method can be difficult to implement. You can’t select the data range before you start uploading the macro as it won’t stay selected.Īfter that, all the empty columns should be erased and all filled columns should be next to each other. The most common way to delete blank lines in Excel, at least as mentioned online, is to use some sort of Excel macro. If you drag this out with your mouse or by holding Shift and using the arrow keys, you will notice that:

The letters correspond to the column and the numbers correspond to the rows. Having a reasonable number of columns, you can simply select those that have 'Blank' in the first row (to select multiple columns, hold the Ctrl key as you click the column letters). When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. The work range or data range is the specific interval between columns that you want to target. Sub Main Dim iCol As Long With Worksheets ('mySheetName').UsedRange <- change 'mySheetName' to your actual sheet name For iCol. Input the appropriate work range in the dialog window.Press F5 to compile and execute the macro. Usually when we have a Worksheet containing a lot of data, we find ourselves to have a lot of empty Rows or Columns in it.Set rng = InputRng.Cells(1, i).EntireColumn Set InputRng = Application.InputBox('Range :', xTitleId, InputRng.Address,Type:=8)įor i = To 1 Step -1 Paste the following lines of code in the window.Wait for the Microsoft Visual Basic for Applications window to appear.The first method involves using a VBA macro. But what if your imported project creates 57 empty and non-continuous columns? – For that, you’ll need an automated process.

Sure, if you only have two or three empty columns, it’s quite ok to delete them manually. When it happens, deleting columns manually may not always be easy. You see this happening with CSV files and. 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.

How to delete blank columns in excel spreadsheet