Entering a Function’s Arguments Tooltip in a Cell - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Wednesday, January 22, 2020

Entering a Function’s Arguments Tooltip in a Cell

Entering a Function’s Arguments Tooltip in a Cell
You can press Ctrl+Shift+A in mid-entry of your worksheet functions to show their tooltips’ argument text directly in your cell, and type your function arguments right over those text tips.
Step 1
Start by entering the function name, followed by the open parentheses character.
The function’s arguments tooltip appears as usual.
Step 2
Press Ctrl+Shift+A.
Step 3
The function’s arguments tooltip text now appears in the cell. The tooltip itself is still visible.
Step 4
I dragged the tooltip away from the cell in this example.
Notice I continued to enter my VLOOKUP function arguments in the cell, directly over the tip text.
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment