Show | search
Click here to view Show news from 60+ newspapers.
Bookmark or Share- Filter for unique values or remove duplicate values - Microsoft SupportIn 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.
- Customize the ribbon in Office - Microsoft SupportShow, hide, reset, or share your ribbon, and add, remove, hide, or change order of tabs.
- Display or hide zero values - Microsoft SupportWhether your format standards or preferences call for zeroes showing or hidden, there are several ways to make it happen. Go to File > Options > Advanced. To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
- Hide error values and error indicators in cells - Microsoft SupportThere are several ways to hide error values and error indicators in cells. There 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!.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportIt's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
More
