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.
The Accessibility ribbon puts all the tools you need to create accessible content in one place.
Accessibility Checker keeps an eye on your documents and tells you in the status bar when it finds something you should look at. Try it by clicking Review > Check Accessibility.
Experience improved performance, stability, and speed across Excel.
Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.
No need to unhide one sheet at a time anymore—unhide multiple hidden sheets at once.
We’re constantly adding more rich media content to the Office Premium Creative Content collection that helps you express yourself, such as a curated library of stock images, icons, and more.
At the top of your Microsoft Office apps on Windows, you'll find the new Microsoft Search box. This powerful tool helps you quickly find what you're looking for, such as text, commands, help, and more.
Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.
We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.
Quickly access and change the color of all your inking tools, all in one place.
Simplify how you work with ink using new Draw tab additions: Point Eraser, Ruler, and Lasso.
Wondering how big your worksheet or workbook is getting? Excel provides workbook statistics to help you.
Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. No need to convert Hex color values into RGB values.
For any property where you can define a color, you can now enter a Hex color value in the Hex box, for example, #0F4C81 or 444.
You can give a casual, hand-drawn look to shapes in your workbook with the Sketched style outline.
Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched style.