Click OK.Īll the blank columns from the selected range will be deleted.Blank rows of data can be a big annoyance. This option will shift all the leftover cells left after deleting the blank columns. Step 6: After selecting Delete Cells, a pop-up window will appear(as shown below). Step 5: After selecting Delete a drop-down will appear (as shown in the image). The delete will help to delete the selected row, column, cell, and entire sheet. Step 4: Then go to the Home tab>Cells Group>Delete i.e go to the Home tab and in the Cells group click on Delete(as shown below). This operation will select all the blank columns from the selected data. Click on Blanks (as shown) and then select OK. Step 3: After selecting special, a window (as shown below) will appear. The special feature allows users to select all that has matching criteria as selected such as blanks, numbers, formulas. A dialogue box will appear(as shown below) and select Special. Step 2: Select all the data by selecting the required rows and columns and press F5 from the keyboard. Step 1: Open the required Excel where you want to delete the blank columns. We can also be deleting blank columns in MS Excel using Go To. Deleting blank columns in Excel using Go To Repeat the same steps for all the blank columns left in the required worksheet and delete them. A drop-down will appear (as shown below). Step 2: Then right-click on the selected column. Step 1: Select the blank columns, to select the blank columns press Shift and press the down arrow to the row upto you want to select the column. Now we understand this method with the help of an example. If you have a large number of columns to delete then move on to the second method. This method works with all types of data but it is time taking, here I would suggest to use this method only when your data is less.
Easy way to delete empty rows in excel manual#
We can delete blank columns in Excel using manual selection and deletion. Deleting blank columns in Excel using manual selection and deletion Note: The tutorial is for Microsoft Excel 2013. You may find the same or different steps in other Microsoft Excel versions.
Easy way to delete empty rows in excel how to#
0 kommentar(er)
