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.
______
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 ______
On TikTok, I follow Bryan Nothling aka thebnoth, because he’s funny, and he’s Canadian! His “working from home” videos have brightened my days, and he has over 200K followers, so I’m not the only person who enjoys them.
Sometimes a VLOOKUP formula returns an #N/A error, even though you can see the value you’re looking for in the lookup table. The most common cause for this is a text “number” in one place, and a real number in the other place. See how you can fix that VLOOKUP problem.
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…
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. _________________
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 ______________________