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
______
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.
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data. For written instructions please read…
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 ______________
If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers ______________________
In Excel 2003, or earlier versions, you can move the color and border palettes close to the cells you’re formatting. To see the steps, watch this short Excel video tutorial. For written instructions, see the move the color and border palettes in Excel notes on the Contextures website. ______
You can create a user form in Excel, to control how users are able to enter data. These 3 short Excel video tutorials show you the steps. For detailed instructions please visit the web page Create an Excel UserForm. _________________