Choose Blanks and select the OK button to confirm.

Select the cell range, and then select Edit-Go To and click the Special button.

To delete blank cells in Excel Mac we should follow slightly different steps: If we want to delete just blank cells in the selected range, instead of choosing Delete Sheet Rows we should select Delete cells. The final output of removing rows containing blank cells Remove rows that contain blank cellsįinally, all rows that contain empty cells are deleted:įigure 9. We should go to tab Home-Cells-Delete and choose Delete Sheet Rows :įigure 8. First, we have to select the cell range where we want to r emove empty cells in Excel and then to click on the Go to Special button under the tab Home-Editing-Find&SelectĬhoose Blanks and click on the OK button:Īs a result, we want to delete all rows that contain empty cell in the selected range. There is a fast solution to delete blank cells in Excel. Delete a row in Google Sheets Delete Blank Cells in Excel In Google Sheets, we can delete a row by clicking on the cell in the row to be deleted, right mouse clicking and selecting the option Delete row from the list.įigure 5. Delete a row in Excel using Delete tabĬhoose Delete Sheets Rows and row 4 will be deleted: First, we have to select the cell in the row to be deleted and to click on the Delete tab under the section Home-Cells.įigure 3. To delete a row in Excel we can use Delete tab under Home-Cells in Excel. Delete a column in Google Sheets Delete a Row in Excel and Google Sheets In column header in the down right corner open drop-down list and choose option Delete column.įigure 2.

To delete columns in Google Sheets logic is almost the same.

If we want to delete a column in Excel we have to select the column by clicking on the column header and to do the right mouse click and choose the Delete option in the drop-down list. Delete a Column in Excel and Google Sheets This step by step tutorial will assist all levels of Excel users to combine multiple columns in Excel and Google Sheets into one column. Combine columns into one list with CONCATENATE function.There are several ways to merge excel columns, but the commonly used are:

How to Delete Columns and Rows in Google Sheets and ExcelĮxcel Merge button is not the appropriate solution to combine columns into one list without losing the data because it keeps only the value from the upper left cell from the selection:

How to add multiple rows in excel mac