Tom’s Tutorials For Excel: 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.

Tom’s Tutorials For Excel: Entering a Function’s Arguments Tooltip in a Cell
Tom’s Tutorials For Excel: 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.Tags: Analytics, Big Data, Business Intelligence, Cells Ranges Lists, Comments / Screen Tips, Data Science, Excel Expert, Excel Guru, Formulas Functions, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis