Welcome to the January 2023 update. This month we are excited to announce the release of PivotTable show details to Excel for the web and the ability to automate your tasks with the Power Automate tab in Excel for Windows and Mac. For Insiders users on Windows and Mac, you can try recording your worksheet actions using Office Scripts and checking your formula with the value preview tooltip.
Curious to see how we at Excel utilize and implement your feedback? You can now see which features are a direct result of your feedback as they'll be marked with the Feedback In Action tile #FIA.
| Check out this Excel Features Flyer to find if a specific feature is in your version of Excel |
Excel for the web:
- PivotTable show details #FIA
Excel for Windows:
- Automate your tasks with the Automate tab
- Record worksheet actions using Office Scripts (Insiders)
- Check your formula with value preview tooltips (Insiders)
Excel for Mac:
- Automate your tasks with the Automate tab
- Record worksheet actions using Office Scripts (Insiders)
- Check your formula with value preview tooltips (Insiders)
Excel for the web
| #FIA! |
PivotTable show details
View the source data for a PivotTable value cell, now in Excel for the web. Double-click or right-click and choose Show Details from a value cell in your PivotTable to create a new sheet with the detailed rows for that cell. There is also a new button to activate the same functionality from the PivotTable tab of the ribbon.
Show Details is useful to help you understand how the values in your PivotTable were calculated. For example, if you see an unexpected value in your PivotTable, you can use Show Details to confirm whether the source data used to calculate that value is as expected or if there is an issue with the underlying data.
Excel for Windows
Automate your tasks with the Automate tab
With this new tab, create and modify scripts that automate your repetitive tasks using Office Scripts. Enhance your workbook by connecting popular applications like Microsoft Teams or SharePoint to build workflows with Power Automate. Combine these productivity technologies to have Power Automate schedule your Office Script. This tab represents the first stage of uniting automation solutions across platforms. Read more >
Record worksheet actions using Office Scripts (Insiders)
Before, you could create and modify automations using JavaScript and TypeScript using the Office Scripts Code Editor. Now, with the Action Recorder, you can automate repetitive worksheet tasks without needing any programming experience. Read more >
Check your formula with value preview tooltips (Insiders)
Simply select any part of the formula you want to evaluate and Excel will display a tooltip that contains the current value of that parameter that you highlighted. Read more >
Excel for Mac
Automate your tasks with the Automate tab
With this new tab, create and modify scripts that automate your repetitive tasks using Office Scripts. Enhance your workbook by connecting popular applications like Microsoft Teams or SharePoint to build workflows with Power Automate. Combine these productivity technologies to have Power Automate schedule your Office Script. This tab represents the first stage of uniting automation solutions across platforms. Read more >
Record worksheet actions using Office Scripts (Insiders)
Before, you could create and modify automations using JavaScript and TypeScript using the Office Scripts Code Editor. Now, with the Action Recorder, you can automate repetitive worksheet tasks without needing any programming experience. Read more >
Check your formula with value preview tooltips (Insiders)
Simply select any part of the formula you want to evaluate and Excel will display a tooltip that contains the current value of that parameter that you highlighted. Read more >
Check if a specific feature is in your version of ExcelClick 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.
