What's New in Excel (October 2022)
Published Oct 25 2022 06:00 AM 13.1K Views
Microsoft

Welcome to the October 2022 update. This month, we had Microsoft Ignite taking place on October 12-14 - check out this What's New in Excel video from our team. Also, Navigation Pane is now generally available (GA) on Excel for Windows - GA coming soon on Excel for Mac. For Windows and Mac Insiders, we're excited to announce Automate Tasks with Office Scripts enabling you to automate repetitive tasks in your spreadsheet workflows. What's more? Insider users of Excel for Windows, you can now paste values using Ctrl+Shift+V.

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel

 

Excel for the web:

  • Quickly Find the Command you need

Excel for Windows:

  • Automate Tasks with Office Scripts (Insiders Beta)
  • Navigation Pane
  • Quickly Find the Command you need
  • New DAX Functions in Excel Data Models and Power Pivot (Insiders Beta)
  • New Paste Options when using keyboard shortcuts (Insiders Beta)

Excel for Mac:

  • Automate Tasks with Office Scripts (Insiders)

Excel for the web

Quickly Find the Command you need

It is now easier to find the command that you need using the shortcut menu, this will save you time and allows you to focus more on the task at hand. Read more here >

 

Excel for Windows

Automate Tasks with Office Scripts (Insiders Preview)

Office Scripts enables you to automate repetitive tasks in your spreadsheet workflows. These scripts help you save time by increasing efficiency and reducing errors in your workflow, and you can even schedule your scripts so that your automations can run even while you’re away. Read more here >

Automate Tasks with Office ScriptsAutomate Tasks with Office Scripts

 

Navigation Pane

The Navigation pane in Excel is an easy way to understand a workbook's layout, see what elements exist within the workbook, and navigate directly to those elements. Whether you're a new user getting familiar with Excel, or an experienced user trying to navigate a large workbook, the Navigation pane can help. 

Find and access elements such as tables, charts, PivotTables, and images within your workbook. Once you've opened the Navigation pane, it displays on the right side of the Excel window. The Navigation pane also makes it easier for those with visual impairments to access all parts of the workbook. It can improve how tools such as screen readers interpret your workbook. Read more here >

 

Quickly find the command you need

It is now easier to find the command that you need using the shortcut menu, this will save you time and allows you to focus more on the task at hand. Read more here >

 

New DAX Functions in Excel Data Models and Power Pivot (Insiders Beta)

Excel’s Data Model and Power Pivot are tools that help you analyze data across multiple tables, and support a powerful expression language called DAX. Using the power of the Data Model, you can quickly relate various data sets to create PivotTables and Pivot Charts. Note that this is the same technology used by Power BI.

 

You can now use 92 new DAX functions when creating measures in Power Pivot. This provides you with new capabilities to analyze, visualize, and report on your data. Read more here >

Insert new DAX FunctionsInsert new DAX Functions

 

New Paste Options when using keyboard shortcuts (Insiders Beta)

It’s common to copy text from a web page, an email, or another document, and then paste it into Excel. Often, your goal is to match the format that’s already in place in the cell or range where you’re pasting. Now you can simply copy the content that you want to paste into an existing worksheet and press Ctrl+Shift+V. Read more here >

 

Excel for Mac

Automate Tasks with Office Scripts (Insiders)

Office Scripts enables you to automate repetitive tasks in your spreadsheet workflows. These scripts help you save time by increasing efficiency and reducing errors in your workflow, and you can even schedule your scripts so that your automations can run even while you’re away. Read more here >

 

 

Check if a specific feature is in your version of Excel

Click here to open in a new browser tab

 

 

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

 

6 Comments
Version history
Last update:
‎Oct 26 2022 12:52 PM
Updated by: