Search Contextures Sites
Excel Weekly News from Contextures Mar 12, 2012Add a popup picture on an Excel worksheet, separate dates in an Excel table, and other tips for you, in this week's Excel news from Contextures.
Add a Popup Picture in an Excel CommentDid you know that instead of text, an Excel comment can contain a picture? With this trick, you can add pictures in an Excel worksheet to help explain the data. For example, if you're selling garden products, you could add pictures of the plants and garden tools.
To add a picture that is tied to a specific cell, you can insert a picture in an Excel comment. The pictures will be hidden until the user wants to see them, so the pictures won't clutter up the worksheet.
Point to a cell that has a comment (marked with a red triangle), and the picture will pop up on the worksheet.
You can find written instructions on the Contextures website:
Or, watch the steps in this short video, that I posted on YouTube.
Separate Dates in Excel ListHere is a simple technique that separates the dates in a sorted Excel list. It creates automatic lines, based on conditional formatting
I've also uploaded a video that shows the steps for creating these automatic lines. You can see the video in the blog post, or watch it on YouTube
Data Validation DocumenterCan you remember all the data validation rules that you've set up on your worksheet?This article on the Contextures Blog shows how to list your Excel worksheet's data validation cells and rules.
Add a Watermark to an Excel Worksheet
This week, the Excel team at Microsoft showed how to add a watermark to a worksheet. With this technique, you can show "DRAFT" or "CONFIDENTIAL" on the sheet, in a faded colour.
Who Says The Ribbon Is Hard?
If you're looking for a new challenge, Excel MVP, Bob Phillips, shows us how to use Excel VBA to change the Ribbon commands.
Bob says, "Hopefully you can see how simple it is to create dynamic ribbon customisations, and how to manage the changes within your VBA code."
There is a sample workbook that you can download, and that should make the example easier to follow and understand.
Excel HumourOnce again, I read the Excel tweets, so you don't have to! Here are a few favourites from this week. You can read the rest of the tweet collection here.
- It happened. I fell in love with Excel.
- When the teacher says "Oh just make the graph on Excel, it'll take you less than half the time than drawing it" Do. Not. Believe. Him.
- OH: I'm not eating alone, my Excel Spreadsheet is with me.
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Contextures Inc., Copyright ©2018
All rights reserved.