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
______________
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 ______
In Excel, there’s no built-in Panel Chart type, but you can create line panel charts, like the one shown below. Watch a video, to see the steps, and there’s a transcript too, and a link where you can download the sample Excel file.
You can quickly change values in Excel, without using formulas. Follow the steps in this short video to add, subtract, multiply or divide, by a specific amount or percentage. For detailed instructions, please visit Excel data entry tips. ______________
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. ________________
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. _________________
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. ______