Log in
x
or
x
x
Register
x

or

Excel Tips: Edit > Delete and Clear

Clear Cell Content

How to clear cells if they appear blank but are not in Excel?

How to clear contents and formatting at the same time in cells in Excel?

How to clear contents of named range in Excel?

How to clear entire sheet or specified range in Excel?

How to clear specified cell contents if value of another cell changes in Excel?

How to clear specified cell contents on open and exit in Excel workbook?

How to clear the contents of multiple merged cells in Excel?

How to delete string after nth character in Excel?

How to prevent specific cell contents from being deleted in Excel?

How to quickly delete all contents of unlocked / unprotected cells in Excel?

How to quickly remove all numberings or bullet points from an Excel column?

Clear Cell Formatting

How to clear contents and formatting at the same time in cells in Excel?

How to clear table formatting style without losing table data in Excel?

How to quickly clear or remove all formatting of cells in Excel?

How to quickly remove conditional formatting in Excel?

How to remove bold font of pivot table in Excel?

How to remove bold font of pivot table in Excel?

How to remove conditional formatting but keep format in Excel?

How to remove conditional formatting from blank cells in Excel?

How to remove fill color from cells in Excel?

Clear Content of Objects

How to clear contents of combo box with VBA code in Excel?

How to clear contents of textbox when clicked in Excel?

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?

Delete Illustrations, Objects, or Charts

How to convert html to text in cells in Excel?

How to delete all charts in Excel Workbooks?

How to delete all comments in a worksheet/workbook?

How to delete all pictures in a range of cells?

How to delete all pictures or other objects in Excel easily?

How to delete one or all pivot tables in Excel?

How to delete SmartArt only in Excel?

How to insert and delete images or background images in Excel

How to quickly delete all autoshapes in Excel?

How to quickly delete all html objects in Excel?

How to quickly delete all text boxes in Excel?

How to quickly remove watermark in Excel?

How to remove / delete all or multiple hyperlinks in Excel?

How to remove all buttons or Command buttons in Excel?

How to remove all HTML tags from string in Excel?

How to remove all Macros in Excel?

How to remove line shapes in Excel?

Delete Sheets

How to delete all sheets except specified/current one in Excel?

How to delete all the blank worksheets in Excel?

How to delete hidden worksheets in Excel?

How to delete sheet if name contains specific text from workbook?

How to delete sheet if sheet name not in a list?

How to delete specific sheet if exists in workbook?

How to delete worksheet based on cell value in Excel?

How to delete worksheet without prompt or warning in Excel?

How to remove empty sheets from a workbooks

Remove Characters

Remove Alpha or Numeric Characters

How to remove alpha characters from cells in Excel?

How to remove letters from strings/numbers/cells in Excel?

How to remove non numeric characters from cells in Excel?

How to remove non-alpha characters from cells in Excel?

How to remove non-alphanumeric characters in Excel?

How to remove non-English characters in Excel column?

How to remove numbers from cells which containing texts and numbers in Excel?

How to remove numbers from text strings in Excel?

How to remove numeric characters from cells in Excel?

How to remove only text from cells that containing numbers and texts in Excel?

How to quickly remove all numberings or bullet points from an Excel column?

Remove Non-printing Characters

How to delete all blank lines or only the first line in cell in Excel?

How to quickly remove line breaks in Excel?

How to remove non-printable characters from cells in Excel?

Remove Punctuation Marks

How to remove all brackets from string in a range in Excel?

How to remove all commas in Excel?

How to remove all punctuation marks (comma, quotation, apostrophe) from cells?

How to remove first comma from text string in Excel?

How to remove last / ending comma from cell in Excel?

How to remove last/first character if it is a comma or certain character in Excel?

How to remove quote marks around text from cell in Excel?

Remove Characters by Position

How to remove all but first x characters from cells in Excel?

How to remove all characters after the first/last space from cells in Excel?

How to remove anything in brackets in Excel?

How to remove extension from filename in Excel?

How to remove first / last word from text string in cell?

How to remove first or last n characters from a cell or string in Excel?

How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?

How to remove inverted commas from cells in Excel?

How to remove last / ending comma from cell in Excel?

How to remove last/first character if it is a comma or certain character in Excel?

How to remove leading apostrophe from numbers in Excel?

How to remove leading minus sign from numbers in Excel?

How to remove middle initial from full name in Excel?

How to remove negative sign from numbers in Excel?

How to remove prefix / suffix from multiple cells in Excel?

How to remove text before or after a specific character from cells in Excel?

How to remove text indicator (‘) in Excel?

How to remove text within brackets/parentheses in Excel?

Remove Specified Characters

How to quickly remove dashes from cells in Excel?

How to remove all asterisk characters from cells in Excel?

How to remove all instances of a character in Excel range?

How to remove certain/specific character from cell in Excel?

How to remove plus sign or minus sign of data in Excel?

How to remove some special characters from string in Excel?

How to quickly remove all numberings or bullet points from an Excel column?

Remove Zeros

How to remove all zeros after decimal in Excel?

How to remove leading zeros before decimal point in Excel?

How to remove leading zeros from alphanumeric text string in Excel?

Others

How to mass delete specific word in Excel?

How to remove all decimal points but retain value in Excel?

How to remove duplicate characters or words in string of a cell?

How to remove salutations from names cells in Excel?

How to remove unwanted text from cell in Excel?

Remove Spaces

How to remove extra spaces between words in cells in Excel?

How to remove internal spaces in Excel string?

How to remove leading and trailing spaces in Excel ?

How to remove leading spaces in cells in Excel?

How to remove spaces between characters and numbers within cells in Excel?

How to remove trailing spaces from cells in Microsoft Excel?

How to remove whitespace after text in Excel?

How to remove/delete all spaces after the last character in Excel?

How to replace multiple spaces with single space from cells in Excel?

Others

How to batch remove hyperlinks at once in Excel?

How to delete active workbook (current file) in Excel?

How to delete all but selected ranges in Excel?

How to delete drop down list in Excel?

How to delete extra empty or blank pages in a worksheet in Excel?

How to delete tracer arrows in Excel?

How to quickly delete all named ranges in Excel?

How to remove personal information of a workbook?