how to delete blank columns in excel spreadsheet

Click the Find All button to get all the blank cells.

For this example, we use these options to limit the search: within the Sheet, search By Rows, and look in the Values.

Select the Options button and check the box for Match entire cell contents.

You wouldn’t want to delete an entire row and lose those cells with data. Note: Avoid this method on sheets where only a few cells are empty instead of entire rows. You can also use the Ctrl + F keyboard shortcut to bring up the Find and Replace dialog box. Use it to find all empty rows in a sheet or the entire workbook and then delete them in one go. The Find and Replace command is under the Find & Select button on the Home tab. But it gets cumbersome if you have to scroll around to find and then select multiple blank rows. Using the simple delete command is enough when you just have a few blank rows in your spreadsheet. Use the Find command to search and remove blank rows in Excel Re-sort the data according to this index column and then delete it.

To get back the original order, you can add an index column before you sort the data.

Blank rows will be sorted at the bottom of the selected range (indicated by colored rows in the screenshot below). Here you can select either the Sort A to Z or Sort Z to A button to sort in ascending or descending order. Select the range of rows in the spreadsheet. A simple sort will bunch all blank rows together and help you quickly remove them. Sorting your data will not only help to organize your data but this can also bring out blank rows you do not need.

Use a simple sort to find and remove blank rows in Excel The row numbers will also update to stay in sequence. Those rows below the deleted ones will be moved up to replace the deleted space.

Right-click anywhere on this row and select Delete.

You can select multiple rows by pressing Ctrl and clicking on the row number. Highlight the entire row by selecting the row number on the left side of the screen.When there are a small number of rows, you can quickly spot the blank rows and remove them with a selection. How to remove blank rows in Excel manually

How to delete blank columns in excel spreadsheet