Having blank cells in your Excel spreadsheet is not what you need when you want to keep your data in order. This article will teach you how to remove empty cells in Excel.
Delete Empty Excel Cells Manually
This method is suitable if you need to remove only a few cells. It is not different from other methods, except it has a stressful selection process of multiple empty cells involved. There are three ways you can manually delete empty cells:
Using Your Mouse
- Hold the Ctrl key and click on the empty cells you want to delete.
- After these cells are selected, right-click on one of the selected cells.
- Choose the Delete option in the menu.
Using Keyboard Shortcut
- Select the empty cells by clicking on them while you hold the Ctrl key.
- Release the Ctrl key after you have selected all the empty cells you want to delete.
- Press Ctrl + - on your keyboard to delete the selected cells.
Using Ribbon Command
- Click on the empty cells while holding the Ctrl key to select them.
- Go to the Home tab.
- Click on the Delete command in the options.
- Next, click on Delete Sheet Rows.
Delete Empty Cells Using Go To Special Command
Manually selecting empty cells is stressful, especially if you have a lot of these cells. However, there are other ways you can easily select these cells, and using the Go To Special command is one of them. Follow these steps to delete empty cells using the Go To Special command:
- First, you need select a column that contains all the blank cells. If there are empty cells in multiple columns, you can select the first cell, hold the shift key and then select the last cell.
- Go to the Home tab.
- Click on Find & Select.
- Choose the Go To Special option from the menu.
- Alternatively, you can press Ctrl + G on your keyboard and click on Special to open the Go To Special menu.
- Select Blanks from the options in the menu and press Ok. It will select the empty cells you want to delete.
- Right-click on the selected empty cells and select delete.
- In the Delete menu, select Entire Row, then click on Ok.
Delete Empty Cells Using Find Command
This method is similar to the Go To Special command and is suitable for deleting multiple empty cells. Follow these steps to delete empty cells using Find Command.
- Select the column containing the empty cells you want to delete. If the empty cells are in multiple columns, select the first cell, hold the shift key and select the last cell.
- Go to the Home tab.
- Click on Find & Select.
- Choose Find from the Find & Select menu.
- Alternatively, you can press Ctrl + F to open the Find menu.
- Next, select Options from the on-screen prompt.
- Click on the Match entire cell contents box.
- Select Sheet in the Within menu, Rows in the Search menu, and Values in the Look menu.
- Click on Find All. It will bring a list of empty cells found in the selected range.
- Select all the empty cells by pressing Ctrl + A on your keyboard.
- Close the Find menu by clicking on Close.
- Since the empty cells are selected, you can use any manual deleting methods discussed earlier.
Delete Empty Cells Using Filters
Follow these steps to use filters in finding empty cells and deleting them:
- Select the range of data that contains empty cells.
- Go to the Data tab.
- Go to the Sort & Filter section and click on Filter. Alternatively, you can press Ctrl + Shift + L on your keyboard. It will add sort and filter toggles to the column headings.
- Click on the filter toggle in any of the column headings.
- Click on the Select All option.
- Check the Blanks box.
- Click on Ok. When you do this, the numbers of filtered rows will appear in blue. If a whole row is filtered, its number will be missing from the spreadsheet data.
- Now, select the rows with blue numbering and delete them using the manual deletion methods discussed earlier.
- Confirm the deletion by clicking Ok.
After you complete these steps, the data will remain, but the empty rows will still appear. Follow these steps to filter out these blank rows:
- Click on the Filter toggle on one of the columns.
- Uncheck the Blanks button.
- Click on Ok.
- Copy and paste the data to a new location.
Conclusion
Empty cells can affect your spreadsheet data, and their removal is necessary. This article has explained some of the best ways you can remove these empty cells and get a flawless Excell spreadsheet.
You may also like to read:
How To Change Date Format In Excel To dd/mm/yyyy
Export Google Calendar To Excel
How to Add Background Image to Google Calendar Event
How To Add Months To Date In Google Sheets
If Contains Google Sheets Formula (With Examples)
how to export google calendar to google sheets