I want to share with you three things that you may not know about the Function ScreenTip, which is the box that appears just below the function you're editing or writing.
1. Clicking the argument name will highlight the corresponding text in the function.
Each of the sections in a function corresponds with an argument name in the Function ScreenTip. If you click anywhere in the function, it will bold the argument name in the ScreenTip. On the other hand, clicking any of the arguments in the Screentip will highlight the corresponding text in the formula.
This can be helpful for editing specific portions of the function.
2. Clicking on the function name in the Function ScreenTip will open up the Help menu for that function. This menu gives all sorts of practical information about the function, including what it's used for, what each of the arguments does, and examples of how to use the function.
3. The ScreenTip can be moved.
Finally, many people don't realize that you can relocate the Function ScreenTip if you find that it's getting in your way. Just hover over the border of the ScreenTip, left-click, and then drag it to wherever you'd like it to be.
Also, if you want to turn off the ScreenTip completely, you can do so in Excel Options.
If you have any questions about the Function ScreenTip, just leave a comment below. We're happy to help!
How to zoom in on the syntax in the function window/dialogue box when typing M-formulas in Power Query or any other function window in Excel. What are the shortcut keystrokes to increase the visibility of the cursor and the string syntax in the dialogue box?