Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Ann from Wisconsin writes with a really annoying Wrap Text problem in Excel 2003. Episode 999 suggest a few workarounds to solve the problem.
posted by Bill at 9:00 AM
A second solution to Don's problem from podcast 991: add a textbox inside the cell. With a bit of formatting, the words inside the textbox will appear to float next to the number, but will not cause any subsequent formulas to incorporate the text. Episode 992 shows you how.
Labels: Textbox
posted by Bill at 9:00 AM
One of my favorite tricks is to fill a textbox with the result of a formula in the worksheet. When you try this as the title in an embedded chart, you need to change the formula to point back to the original worksheet. Episode 778 shows you how.
posted by Bill at 9:00 AM
Joe Marten sends in a better way to limit the number of characters entered in a cell. Episode 599 shows you how.
Labels: Textbox
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
Are you a fan of Edit – Fill – Justify? If so, watch out if you try to justify particularly long text – anything over 255 characters in a cell. Excel fails miserably, and you lost part of your text, without any warning from Excel. Episode 567 shows you the details.
Labels: Editing, Justify, Microsoft Word, Textbox
posted by Bill at 9:00 AM
How to use Excel as a word processor. This episode again covers the Edit - Fill - Justify command, but also shows off the cool ability to create a two column text box in Excel 2007. Episode 408 shows you how.
posted by Bill at 9:00 AM
