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,
…
Tom’s Tutorials For Excel: Selecting All Cells With Comments or Data Validation
Tom’s Tutorials For Excel: Selecting All Cells With Comments or Data Validation
I previously posted this example of selecting only constants or formulas.
You can do the same with cells that contain comments or data validation.
Select the range of interest.
…
Read more ›
Tags: Analytics, Big Data, Business Intelligence, Cells Ranges Lists, Comments / Screen Tips, Data Science, Data validation, Excel Expert, Excel Guru, Formulas Functions, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis