In Office 2021, you'll find new inking tools, data types, functions, translation and editing tools, motion graphics, ease-of-use features, and so much more! Check out what's available to you today.

Note: All features listed here, unless otherwise noted, are also included in Office LTSC for commercial customers.

Your browser does not support video.

Look left, look right… XLOOKUP is here!

Row by row, find anything you need in a table or range with XLOOKUP.

New in: Excel

LEARN MORE

Screenshot of Excel with data using dynamic arrays

Dynamic arrays

Write one formula and return an array of values. Expedite calculations and insights with six new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, and RANDARRAY.

New in: Excel

LEARN MORE

Your browser does not support video.

LET function

The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula.

New in: Excel

LEARN MORE

Example of using XMATCH to find the position of an item in a list

XMATCH function

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.

New in: Excel

LEARN MORE

Your browser does not support video.

New and improved Record Slide Show

Record Slide Show now supports presenter video recording, ink recording and laser pointer recording.

New in: PowerPoint

LEARN MORE

Your browser does not support video.

Replay your ink strokes

You can replay your ink strokes as they were drawn; this lets you illustrate things step by step or show a thought process. You can also pause the replay, and select the point to start the replay from.

New in: PowerPoint

LEARN MORE

List of items in reading order on a slide with up- and down-arrow buttons to rearrange them

Arrange elements on your slides for screen readers

See the elements in screen-reading order and re-arrange them as necessary to communicate your message effectively.

New in: PowerPoint

LEARN MORE

This message was translated from English to French using the Outlook Translator Add-In

Translator and ink in Outlook

Translate email messages into more than 70 languages on the fly and view the transcript—all within Outlook.

Annotate email images or draw in a separate canvas using your finger, pen, or mouse.

New in: Outlook

LEARN MORE

Your browser does not support video.

In Outlook, use Instant Search to quickly find emails

Select the search bar (located above the Outlook ribbon) to help find email messages anywhere in Outlook.

New in: Outlook

LEARN MORE

Excel 2021 start screen with a list of recently opened workbooks displayed

Visual refresh

Work with a modernized Start experience and newly refreshed tabs in the ribbon.

Experience a clean, clear style with Monoline iconography that communicates action and features with simple visuals.

New in: Word Excel PowerPoint Outlook

Your browser does not support video.

See what’s new in stock media

We’re constantly adding more rich media content to the Office Premium Creative Content collection, a curated library of stock images, icons, and more that helps you express yourself.

New in: Word Excel PowerPoint Outlook Visio

LEARN MORE

Your browser does not support video.

Find what you need with Microsoft Search

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, from text to commands to help and more.

New in: Word Excel PowerPoint Outlook OneNote

LEARN MORE

Screenshot of Excel data using the SUMIF function

Performance improvements

Experience improved performance, stability, and speed across Word, Excel, PowerPoint, and Outlook​.

Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.

New in: Word Excel PowerPoint Outlook

Microsoft 365 Drawing Tools pens

Updated Draw tab

Quickly access and change the color of all your inking tools in one place.

Simplify how you work with ink using new Draw tab additions: Point Eraser, Ruler, and Lasso.

New in: Word Excel PowerPoint

LEARN MORE

The AutoSave Toggle in Office

Save your changes as they happen

Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.

New in: Word Excel PowerPoint

LEARN MORE

List of file formats from Word with ODT file format highlighted

Support for OpenDocument format (ODF) 1.3

We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.

New in: Word Excel PowerPoint

LEARN MORE

Linked Table Manager dialog box

Refresh, relink, or remove linked tables

The updated Linked Table Manager is a central location for viewing and managing all data sources and linked tables in an Access database. See all the improvements we've made to the Linked Table Manager based on your feedback.

New in: Access

LEARN MORE

Shows Access datatype

Try the new the Date/Time Extended data type in Access

To enhance syntax compatibility with SQL and to increase accuracy and level of detail in records that include dates and times, we’ve implemented the SQL DateTime2 data type into Access.

New in: Access

LEARN MORE

A data table with tabs that can be rearranged

Keep tabs on your database objects in Access

You can clearly see the active tab, easily drag tabs to rearrange them, and close database objects with just one click.

New in: Access

LEARN MORE

AWS stencils and shapes

New Azure stencils and shapes in Visio

We've added many more stencils to help you create up-to-date Azure diagrams. You can use these new stencils to build Azure diagrams for network topologies, virtual machine configurations, operations, and more.

New in: Visio

LEARN MORE

Template for AWS: SAP using SIOS

New AWS stencils and shapes in Visio

We have enabled infrastructure shapes from another major cloud provider: Amazon Web Services (AWS). You can now use stencils with the latest AWS shapes to help you create diagrams.

New in: Visio

LEARN MORE

Visio template for a floor plan with social distancing.

Content for social distancing planning in the workplace

Many workplaces need to be re-planned to follow the social distancing guidelines in force. This new Visio template, and the Workplace Social Distancing stencil, provide a number of shapes, fill patterns and line patterns, both scaled and unscaled, to help with this process.

New in: Visio

LEARN MORE

Line format options in Mac with Sketched style selected

Try the Sketched style outline

You can give a casual, hand-drawn look to shapes in your presentations with the Sketched style outline.

Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched style.

New in: Word Excel PowerPoint

LEARN MORE

Color picker in Office apps. Under the RGB fields there is a new field to enter Hex color value.

Pick the perfect color

Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. Now you won't have to spend time converting 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.

New in:

Access Word Excel PowerPoint

Outlook OneNote Visio Project

What's new in your favorite Office app

OneNote Project
Your browser does not support video.

Look left, look right… XLOOKUP is here!

Row by row, find anything you need in a table or range with XLOOKUP.

New in: Excel

LEARN MORE

Screenshot of Excel with data using dynamic arrays

Dynamic arrays

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.

New in: Excel

LEARN MORE

Your browser does not support video.

LET function

The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula.

New in: Excel

LEARN MORE

Example of using XMATCH to find the position of an item in a list

XMATCH function

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.

New in: Excel

LEARN MORE

Watch window in Excel 2021 for Mac displaying Name, Cell, Value, and Formula

Watch your formulas

Watch cells across multiple sheets and books in a single pane or window.

The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets.

New in: Excel

LEARN MORE

Page Color Options shown for Immersive Reader in Word for the Mac

Immersive Reader advanced color support

In Immersive Reader, we've added many additional ways you can choose a page color. Selecting a page color can make text easy to scan with less eye strain.

On the Immersive Reader tab click Page Color to see a 4x5 color picker.

Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.

New in: Word

LEARN MORE

Four voice selection options displayed for Immersive Reader Read Aloud feature

Natural-sounding voices with Read Aloud

The Read Aloud feature in Word's Immersive Reader is great for authors and readers alike. Whether you use it to “prooflisten” a document or an email you’ve drafted to catch errors, or simply to give your eyes a break, Read Aloud now features more natural-sounding voices for an improved listening experience.

To access the feature, click the Read Aloud button on the Review tab.

To switch between different voice options, select the Settings icon at the upper-right corner of your message or document and click the Voice Selection drop-down menu.

New in: Word

LEARN MORE

Your browser does not support video.

Replay your ink strokes

You can replay your ink strokes as they were drawn; this lets you illustrate things step by step or show a thought process. You can also pause the replay, and select the point to start the replay from.

New in: PowerPoint

LEARN MORE

Export as Animated GIF dialog in PowerPoint 2021 for Mac

Make an animated GIF from a slide show

You can now save a presentation as an animated GIF which can be shared via social or other digital channels.

New in: PowerPoint

LEARN MORE

PowerPoint 2021 for Mac window with Take a Tour template opened

Visual refresh

Work with a modernized Start experience and newly refreshed tabs in the ribbon.

Experience a clean, clear style with Monoline iconography that communicates action and features with simple visuals.

New in: Word Excel PowerPoint Outlook

Your browser does not support video.

See what’s new in stock media

We’re constantly adding more rich media content to the Office Premium Creative Content collection, a curated library of stock images, icons, and more that helps you express yourself.

New in: Word Excel PowerPoint

LEARN MORE

Shows Tell me search box

Find what you're looking for

Use the search box to find text, commands, help, and more.

Tell me is a text field where you can enter words and phrases about what you want to do next, and quickly get to features you want to use or actions you want to perform.

New in: Word Excel PowerPoint

LEARN MORE

Screenshot of Excel data using the SUMIF function

Performance improvements

Experience improved performance, stability, and speed across Word, Excel, PowerPoint, and Outlook​.

Get faster calculations from common Excel functions like SUMIF, COUNTIF, and AVERAGEIF.

New in: Word Excel PowerPoint Outlook

Save as dialog in PowerPoint 2021 for Mac with SVG option selected

Save as SVG for your pictures and graphics

We now support saving pictures, charts, and other graphics from your documents in the SVG (Scalable Vector Graphic) format.

Your saved images can be resized with no loss of image quality.

New in: Word Excel PowerPoint Outlook

LEARN MORE

Line format options in Mac with Sketched style selected

Try the Sketched style outline

You can give a casual, hand-drawn look to shapes in your presentations with the Sketched style outline.

Try out the Curved, Freehand, or Scribble options under Format Shape > Line > Sketched style.

New in: Word Excel PowerPoint

LEARN MORE

What's new in your favorite Office for Mac app

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×