Insert ASCII or Unicode Latin-based symbols and characters
Make sure that the NUM LOCK key is on if your keyboard requires it to type numbers on the numeric keypad. To insert a Unicode character, type the character code, press ALT, and then …
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It'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: …
XLOOKUP function - Microsoft Support
1 - Perform a search starting at the first item. This is the default. -1 - Perform a reverse search starting at the last item. 2 - Perform a binary search that relies on lookup_array being sorted in …
Using wildcard characters in searches - Microsoft Support
For more about using wildcard characters with the Find and Replace features in Excel, see Find or replace text and numbers on a worksheet. For example, fy06~? finds "fy06?" Use wildcard …
Change the scale of the horizontal (category) axis in a chart
The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) …
View, manage, and install add-ins for Excel, PowerPoint, and Word ...
In the Office dialog, select tab. If you are not able to see your add-ins, select Refresh to reload your add-ins. When an installed add-in requires access to your device capabilities, such as …
Add a legend to a chart - Microsoft Support
Click the Identify Cell icon , and select a cell. Click OK. Create a chart from start to finish. Get Microsoft chart templates. Learn how to add a legend to a chart, retrieve a missing legend, …
Use conditional formatting to highlight information in Excel
The example shown here works with several examples of conditional formatting icon sets. You can choose to show icons only for cells that meet a condition; for example, displaying a …
Format text or numbers as superscript or subscript
There are several ways to apply superscript and subscript to text or numbers in your worksheet. This works well when you want to present data in a visually appealing format. To format …
Overview of formulas in Excel - Microsoft Support
Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use …
Icons: A new kind of Office clip art - Microsoft Support
Icons are customizable: You can color, resize, style, and rotate icons with no loss of image quality. For more details, see Insert icons in Office. Work with icons in an Office document. …