Share this article
Latest news
With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low
Copilot in Outlook will generate personalized themes for you to customize the app
Microsoft will raise the price of its 365 Suite to include AI capabilities
Death Stranding Director’s Cut is now Xbox X|S at a huge discount
Outlook will let users create custom account icons so they can tell their accounts apart easier
Everything new in Microsoft Excel for the month of January 2023
3 min. read
Published onFebruary 1, 2023
published onFebruary 1, 2023
Share this article
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
In this article
Toggle
Microsoft has released a list highlighting all thenew features that made it to Microsoft Excel in January. We’ve already seen a couple of these features like the new tooltips designed to help userscheck their formulas directly in the formula baras well as the Action Recorder that lets usersrecord repetitive spreadsheet tasks.
This post will highlight key features that made it to Excel this past month. Here’s everything you need to know:
Excel for the web
First up is the added capability that allows users to check the source data for a PivotTable value cell thus allowing them to better understand how values in the table were calculated.
To access this feature, simply “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”. Microsoft has also incorporated a new button that lets you achieve the same from the PivotTable tab of the ribbon.
Excel for Windows
Microsoft has added a new capability that allows users to automate their tasks using the Power Automate tab. This feature lets users create and modify scripts that will in turn automate repetitive tasks using Office Scripts. What’s more, you can link apps like Microsoft Teams or SharePoint to build workflows with Power Automate.
Next up, is theAction Recorderwhich lets you automate repetitive worksheet tasks. Previously, users were heavily dependent on the Office Scripts Code Editor to create and modify automation using JavaScript and TypeScript.
And finally, you can check your formula with the new value preview tooltips by selecting any part of the formula that you want to review. Excel will automatically show you a tooltip that features the current value of the specific section you selected.
Excel for Mac
The Mac client is also getting the same features as the Windows client, that is, the Action Recorder feature, the capability to automate tasks using the Power Automate tab as well as the new value preview tooltips for formulas.
To get information on which features are available to you or find which version of Microsoft Excel you’re on, you can visit theExcel Features Flyer site. That’s it for the month of January folks! Be sure to also check outDecember’s recap postin case you missed it.
Radu Tyrsina
Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time).
For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web.
Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they’re looking for.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Radu Tyrsina
