Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Jan asks if it is possible to shade half of a cell. Episode 905 shows one cumbersome way to do it .
Labels: autoshapes, format
posted by Bill at 9:00 AM
You’ve created a simple macro and want to assign the macro to a button on a worksheet. In today’s question, someone is trying to assign a macro to a button, but it is not working. She can assign the macro to a text box and it works, but not with a button. Episode 594 shows how to assign a macro to a text box, an AutoShape, or a button on the Forms toolbar.
Labels: autoshapes, Macro, Textbox
posted by Bill at 9:00 AM
Although Excel offers 100+ built-in AutoShapes, you can use the various handles on the shape itself, or the tools on the drawing toolbar to morph those shapes into thousands of different shapes. Episode 405 shows you how.
Labels: autoshapes, drawing toolbar, Shapes
posted by Bill at 9:00 AM
Have you ever needed to create many similar autoshapes? You can set the default color, line style, etc and then use an autoshape mode to crank out numerous autoshapes. Episode 404 shows you how.
Labels: autoshapes, color, Shapes
posted by Bill at 9:00 AM
Rather than static text in the AutoShape, use a formula to add dynamic text to an AutoShape. Episode 370 shows you how to create a shape that shows off the total of all sales made today.
Labels: autoshapes, Dynamic, formula, Text
posted by Bill at 9:00 AM
Create cool headlines by adding text to your autoshape and then formatting it using the drawing toolbar. Episode 369 shows you how.
Labels: autoshapes, Formatting, Text
posted by Bill at 9:00 AM
Use the AutoShapes to draw any of 70+ different shapes to your workbook. Episode 368 shows you how.
Labels: autoshapes, Shapes
posted by Bill at 9:00 AM
