Erase—for | search
Click here to view Erase—for news from 60+ newspapers.
Bookmark or Share- Find or replace text and numbers on a worksheetUse the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms.
- Hide error values and error indicators in cells - Microsoft SupportThere are many reasons why formulas can return errors. For example, division by 0 is not allowed, and if you enter the formula =1/0, Excel returns #DIV/0. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Convert an error to zero and use a format to hide the value.
- Clear or remove a filter - Microsoft SupportClear a filter from a column. Click the Filter button next to the column heading, and then click Clear Filter from . For example, the figure below depicts an example of clearing the filter from the Country column. Note: You can't remove filters from individual columns.
- Filter for unique values or remove duplicate valuesIn Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.
- Clear the clipboard - Microsoft SupportThe Clipboard task pane appears on the left side of your spreadsheet and shows all clips in the clipboard. To clear the entire clipboard, click the Clear All button. To delete an individual clip, hover next to the clip, click the arrow to the right of the clip, and click Delete.
More
