Search results
Jun 25, 2024 · Show off your Pride in Excel with a special theme for Mac and iOS users. Welcome to the June 2024 update. This month, prompt Copilot in Excel to work with columns & formulas in Excel for web, Windows, and Mac; navigate and perform tasks more quickly with KeyTips in Excel for Mac, now available to Beta Channel users; and view and open your most ...
- What's new in Excel 2021 for Mac - Microsoft Support
Excel 2021 for Mac allows you to collaboratively work with...
- What's new in Excel 2021 for Windows - Microsoft Support
Excel 2021 for Windows allows you to collaboratively work...
- What's new in Excel 2021 for Mac - Microsoft Support
People also ask
What new features are coming out in Excel?
What new tools are available for Excel?
What's new in Excel 2021?
What's new in Excel 2023?
May 30, 2023 · This month, we are excited to announce several new features across web, Windows, and Mac. The option to directly share a link to a table context menu is now generally available for web users, as well as Immersive Reader which lets you customize your reading experience.
Nov 28, 2023 · This month we are excited to share a number of new features rolling out across Excel for the web, Windows, and Mac. GROUPBY and PIVOTBY, and Export Loop Tables to Excel are both available to Windows and Mac Insiders.
- Overview
- Co-authoring
- Better collaboration with modern comments
- Know who's in your workbook
- Save your changes as they happen
- Sheet views
- Look left, look right… XLOOKUP is here!
- LET function
- Dynamic arrays
- XMATCH function
Excel 2021 for Mac allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly — in a matter of seconds.
LEARN MORE
Have control of when you send comments to your co-authors and be productive with a consistent commenting experience in your workbooks and other Office apps.
LEARN MORE
See who else is working along with you and where they are in the workbook.
Note: This feature is not available in Excel LTSC 2021 for Mac.
Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.
LEARN MORE
Create customized views in an Excel worksheet without disrupting others.
LEARN MORE
Row by row, find anything you need in a table or range with XLOOKUP.
Return exact matches by default—there’s no need to specify.
The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function.
Similar to variables in programming, LET is accomplished through Excel’s native formula syntax.
Write one formula and return an array of values. Expedite calculations and insights with six
more new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.
The XMATCH function searches for a specified item in an array or range of cells, and then returns the item's relative position.
You can also use XMATCH to return a value in an array.
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions.
Jul 27, 2022 · Microsoft rolled out several features for Excel in July 2022, including improved Natural Language Query support. New tools are available for Excel for the web, Windows, and Mac.
Jan 5, 2022 · The Windows, Mac, web, and mobile versions of Excel all received cool new updates that will help us get our jobs done faster. This includes everything from new keyboard shortcuts to advanced (Lambda) functions for complex array formulas.
