Tom’s Tutorials For Excel: Linking a Drawing Object to a Cell
Here’s how you can link a cell’s value to be displayed inside a drawing object. In this example, a Text Box is being used, but this method will also work for Rectangles and other draw-able Forms shapes.
…
Tom’s Tutorials For Excel: Programming Multiple Drawing Shapes
Here’s how you can assign one macro to multiple drawing shapes on your worksheet, and have them all behave uniquely, depending on which shape was clicked.
In the pictured example, four Oval drawing shapes were placed on the worksheet,
…
Tom’s Tutorials For Excel: Inserting a Picture at a Specific Cell on Multiple Worksheets
Suppose you have a workbook, with several worksheets that often require your company logo to be inserted at a particular cell’s location. Assuming…
• You want the picture at the top left corner of cell D3.
…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
Tom’s Tutorials for Excel: Putting a picture in a comment
Tom’s Tutorials for Excel: Putting a picture in a comment
Show comment.
Select comment and right click its edge.
Select Format Comment Colors and Lines tab.
Click drop-down arrow of Color field in Fill section.
Select Fill Effects Picture tab.
Click Select Picture button,
…
Read more ›
Tags: Analytics, Big Data, Business Intelligence, Comments / Screen Tips, Data Science, Excel Expert, Excel Guru, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Pictures Shapes Graphics, Tom Urtis