Excel Tips
Create Dozens of Lightning Bolts »
December 14, 2023
I need to create multiple shapes. In the old Excel, I could double-click a shape icon and then draw multiple copies of the shape without going back to the menu. Now, I can’t seem to double-click the lightning bolt in the Shapes menu.
Place Cell Contents in a Shape »
December 4, 2023
I don’t want to use just static text in a shape; I want to display the results of a calculation in the shape.
November 20, 2023
The oval tool in the Drawing toolbar is hard to use. If I start drawing the rectangle in the upper-left corner of the cell, the shape will start in that corner. But if I start drawing a circle in the same spot, the oval I draw will not completely include the text in the cells. Also, why aren’t there circle and square shapes? I have a hard time drawing perfectly round circles and perfectly square squares.
Circle a Cell on Your Worksheet »
November 17, 2023
Excel offers an excellent calculation tool. However, I know that some people are visually oriented, and their eyes glaze over when they look at a large white sheet with black numbers. I want to use graphics to call attention to certain numbers.
Add Connectors to Join Shapes »
November 16, 2023
Is there a way to join two shapes with a connector?
Draw an Arrow to Visually Illustrate That Two Cells Are Connected »
November 15, 2023
I have a large spreadsheet with many calculations. Results from section 1 are carried forward to cells in section 2. It would help to graphically illustrate that one cell flows to the calculation of another.
November 14, 2023
Excel 2010 introduced the Screenshot icon on the Insert tab. If you open this dropdown, you will see a list of available windows that you can paste as a picture into the worksheet.