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: Commenting a Cell With Data Validation
As a practical alternative to using a comment for supplying information about a cell, consider using Data Validation instead. The advantage is, the user sees the popup message for directions or tips when they select the cell as they enter or edit data.
…
Tom’s Tutorials For Excel: Putting Comments In Formulas With The N Function
You can add a text notation to a worksheet formula by using the N function. This is useful when you want to look at a formula and know something about it by reading actual descriptive words.
…
Tom’s Tutorials For Excel: Showing Excel Help While Entering a Function
Here’s a tip for showing Excel’s Help window for the function you are in the process of entering.
In the picture, the numbers in column C are wanting to be subtotaled. The SUBTOTAL function has 11 different mathematical argument numbers —
…
Tom’s Tutorials For Excel: Updating a Comment to List Unique Items
Here is how you can automatically update a comment that shows unique items in sorted order from the larger worksheet list, whenever a new unique item is added to that list in the worksheet.
In the pictured example,
…
Tom’s Tutorials For Excel: Using a Comment to Log Changes in a Cell
Here’s an easy way to keep a running log of changes to a cell’s text.
Suppose you want your employees to enter an explanation or description of some kind into a cell regarding a topic on your spreadsheet.
…
Tom’s Tutorials For Excel: Hide the right-click Mini Toolbar
In versions 2007 and 2010, there is a mini toolbar that appears when you right-click a worksheet cell. There is an option to show that mini toolbar but not an option to hide it.
In Picture #1,
…
Tom’s Tutorials for Excel: Putting a picture in a comment
Show comment.
Select comment and right click its edge.
Select Format Comment Colors and Lines tab.
Click drop-down arrow of Color field in Fill section.
Select Fill Effects Picture tab.
Click Select Picture button,
…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
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