Microsoft Excel makes it easier to check formulas

2 min. read

Published onJanuary 26, 2023

published onJanuary 26, 2023

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Microsoft has announced theincorporation of new tooltips in Exceldesigned to help users check their formulas directly in the formula bar or in the cell they are editing. Here’s everything you need to know about this neat feature:

Once you select part of the formula, Excel will in turn show you a tooltip that features the current value of the section you are on. Here’s an illustration of how the feature works:

Microsoft further indicated:

A common trick to get the current value of part of a formula is to select that part, then press F9. Doing so replaces the selected part of the formula with its current value. So, you would likely only do this to check the value, and then you press ESC to avoid keeping it as a hard-coded value in your formula.

Alternatively, you can make use of the Evaluate Formula dialog which will also let you see the current value of each part of your formula. If you are part of the Beta channel and running on Windows Version 2302 (Build 16116.20000) or later or Mac Version 16. 70 (Build 230116) or later you should be able to access this feature.

In related news, Excel also got a nifty feature that lets usersrecord repetitive spreadsheet tasksearlier this month dubbed Action Recorder. Share your thoughts with us in the comment section.

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

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#

Microsoft Excel makes it easier to check formulas#

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

Microsoft Excel makes it easier to check formulas