560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls 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
|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:
25 Aytoun Street