Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Edit > Delete and Clear

Delete Cells, Rows, or Columns

Delete Cells

How to automatically remove duplicates form a list in Excel?

How to compare two columns and delete matches in Excel?

How to condense a list to have no blanks in Excel?

How to delete all data but keep formulas in Excel?

How to delete blank cells and move data left in Excel?

How to delete blank cells and shift data up in Excel?

How to delete unique values from a column in Excel?

How to remove all duplicates but keep only one in Excel?

How to remove cells or rows if not bold in Excel?

How to remove duplicates and replace with blank cells in Excel?

How to remove duplicates but keep first instance in Excel?

How to remove duplicates but keep rest of the row values in Excel?

How to remove duplicates that are case sensitive in Excel?

How to remove non-highlighted cells in Excel?

How to remove or delete all strikethrough texts or characters from cells in Excel?

How to remove or split all merged cells in Excel?

How to sort numbers or texts and remove the duplicate records directly in Excel?

How to use shortcut to remove duplicates in Excel column or row?

Delete Rows

Delete Blank Rows

How to condense empty rows /columns in Excel?

How to delete infinite blank rows in Excel?

How to remove blank or empty rows in Excel?

Delete Visible or Hidden Rows

How to delete all hidden rows or columns in Excel?

How to filter a list and delete the rest hidden or visible rows in Excel?

How to only delete visible rows or columns in Excel?

How to reverse (delete) filtered rows in Excel?

Delete Rows by Criteria

How to delete all rows below certain row or active cell in Excel?

How to delete all rows containing specific text within a column in Google sheets?

How to delete entire row if cell contains zero in Excel?

How to delete rows above active cell or specific text in Excel?

How to delete rows based on background color in Excel?

How to delete rows based on duplicates in one column in Excel?

How to delete rows if cell is greater/less than a certain value in Excel?

How to delete rows if cells are blank in a long list in Excel?

How to delete rows if column contains values from the to remove list in Excel?

How to delete rows not containing certain text in Excel?

How to delete rows not matching criteria on another sheet?

How to delete rows with missing/blank values in certain columns in Excel?

How to delete rows with negative values in Excel?

How to remove cells or rows if not bold in Excel?

How to remove rows based on cell value in Excel?

Remove Duplicated or Unique Rows

How to delete same rows or ranges across multiple sheets in Excel?

How to eliminate repeated values (remove duplicates) in Excel?

How to remove both duplicate rows in Excel?

How to remove duplicate rows and keep highest values only in Excel?

How to remove duplicate rows but keep the one with latest date in Excel?

How to Remove Duplicate Rows in Excel ?

How to remove duplicates but keep blank rows in Excel?

How to remove duplicates but leaving lowest value in another column in Excel?

How to remove everything but duplicate rows in Excel?

Remove Every Other Row

How to quickly delete every other row in Excel?

How to select and delete every even rows in Excel?

Others

How to avoid #ref error while deleting the rows in Excel?

How to delete all rows except the first header row in Excel?

How to insert or delete partial row in Excel?

How to insert or delete rows in protected sheet?

How to prevent deleting rows or columns in a shared unprotected workbook?

How to use shortcut keys to insert or delete row/column/tab in Excel?

Delete Columns

How to delete empty columns with header in Excel?

How to delete entire columns based on header value in Excel?

How to delete multiple empty columns quickly in Excel?

How to delete all hidden rows or columns in Excel?

How to only delete visible rows or columns in Excel?

How to prevent deleting rows or columns in a shared unprotected workbook?

How to use shortcut keys to insert or delete row/column/tab in Excel?