Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
A new feature lets you show the value of part of a formula in Excel in a tooltip |
---|
When you select part of a formula in Excel, a values preview tooltip now appears showing you what the results would be for this if you calculated it (removing the need for you to press the F9 key). |
Excel aficionados will already know that they can press the F9 key to evaluate part of a formula:
Pressing F9 here would lead to the selected text being calculated.
For the above example, this is what this would show:
You can now see that the selected part of the formula evaluated to 179.
Typically you would press F9 to see the results of an entire formula without selecting part of it first, then press Esc to return to normal view.
The new Value preview tooltips feature in Excel now allows you to see the results of a formula without pressing any key:
Note that the tooltip will show you the value of what you currently have selected, provided that it's a valid formula. So for this example we see 39.75, which is the result of multiplying 2 * 14 by cell H50.
If your formula is referencing a range, a value tooltip will show all of the value int he range if you select its name:
Here the range Days refers to a block of 11 cells, the values of which are shown in the tooltip.
Note that not everyone will have this new feature yet, but it should be rolled out to you soon if you don't yet have it as part of your Microsoft 365 update path.
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.