What is New in Excel for October 2022


  • Staff
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.

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 (Insiders Preview)
  • 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 >

large

Automate 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 (Insiders Preview)

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.

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 >

large
Insert 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 >

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.

Read more:
 

Attachments

  • Excel.png
    Excel.png
    3.8 KB · Views: 0

Latest Support Threads

Back
Top Bottom