Excel’s popup cell comments aren’t just for text. You can also display pictures in an Excel comment. This short Excel video tutorial explains the simple steps.
For detailed written instructions see: Add a picture to a comment
______
When you open a file in Excel, you might see an "Enable or Disable a Macro” message, but you know that there are no macros in the file. Follow the steps in this video, to prevent this message from appearing. For written instructions see: Remove Excel macro warning ______________
Did you ever set up your Excel workbook exactly the way you want it, with headings in a freeze pane at the top, and hidden gridlines, and other settings? And then one day, all of those settings disappeared? Why did that happen, and how can you prevent that from happening again?
To highlight cells with a value that is too high or too low, you can use Excel Conditional Formatting. This short video shows you the steps. For detailed instructions see Excel Conditional Formatting Basics. ________________
Do you ever use check boxes on your Excel worksheets? They’re handy for choosing options, or marking completed items in a To Do list.
Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False. For example: Check if cell D7 is empty. If it is, the result is an empty string. If not, multiply C7…
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________