Combo | search
Click here to view Combo news from 60+ newspapers.
Bookmark or Share- Add a legend to a chart - Microsoft SupportLearn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
- Customize the Quick Access Toolbar - Microsoft SupportFor example, you can create custom tabs and custom groups to contain your frequently used commands. What do you want to do? Right-click in the ribbon and do either of the following: If the Quick Access Toolbar is shown, select Hide Quick Access Toolbar. If the Quick Access Toolbar is hidden, select Show Quick Access Toolbar.
- Count how often a value occurs - Microsoft SupportUse the COUNTIF function to count how many times a particular value appears in a range of cells. The COUNTIFS function is similar to the function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met.
- Create a drop-down list - Microsoft SupportYou can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
More
