Excel Tips
January 15, 2024
My spreadsheets are blah. How can I make them more eye-catching?
Use Cell Values as the Source for SmartArt Content »
January 11, 2024
As discussed in "Place Cell Contents in a Shape" on page 582, Excel has been able to use values from an Excel cell as the source for text boxes on AutoShapes for fifteen years. It would be obvious to anyone that the best use of SmartArt would be to populate the text pane with cell references. However, nothing I try allows me to specify cell A1 as the source in the text pane. What’s going on?
Switch to the Format Tab to Format Individual Shapes »
January 8, 2024
Birds Eye Scene style notwithstanding, (see Figure 1469 above), I’ve found that most SmartArt formatted using the Design ribbon looks good. Fonts remain consistent throughout. Shapes have similar effects. While giving Microsoft control over font size will usually create a suitable graphic, sometimes I need to tweak the font used within one shape.
January 4, 2024
SmartArt always starts out as a boring blue diagram. What formatting options are available?
January 2, 2024
I typed my text in my SmartArt, but my manager doesn’t like the layout.
Choose the Right Type of SmartArt »
December 25, 2023
I need to illustrate a circular process in which information can flow in both directions. Which SmartArt type should I use?
Draw Business Diagrams with Excel »
December 21, 2023
My manager needs me to graphically document the steps in a project plan.
December 18, 2023
I’m looking for a fun way to kill some time while the Internet is down. Can I make my logo into a Shape that can be formatted using the Drawing Tools?