UNIQUE function - Microsoft Support
Dynamic arrays and spilled array behavior. Implicit intersection operator: @. Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class …
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: …
Turn off Scroll Lock - Microsoft Support
If a check is not visible, Scroll Lock does not appear in the Excel status bar. Simply check the box to have the status appear on the status bar. If Scroll Lock is on, your cursor moves between …
Create or edit .csv files to import into Outlook - Microsoft Support
A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel. Rather than storing information in columns, CSV files store information separated by commas. …
Automatically number rows - Microsoft Support
Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill …
Excel functions (by category) - Microsoft Support
Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These …
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Add alternative text to a shape, picture, chart, SmartArt graphic, …
You can create alternative text (Alt text) for shapes, pictures, charts, SmartArt graphics, or other objects in your Microsoft 365 documents. Alt text helps people with visual disabilities …
Tutorial: Import Data into Excel, and Create a Data Model
In this tutorial, you start with a blank Excel workbook. The sections in this tutorial are the following: Import data from a database. Import data from a spreadsheet. Import data using copy and …
Excel not responding, hangs, freezes or stops working
This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open …