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
Ari sends in a better solution to podcast 677. If you want to prevent text from long cells spilling over to adjacent blank cells, the technique shown in Episode 686 works like a charm. This method might even clean up spills faster than Bounty...
posted by Bill at 9:00 AM
David from Spain sends in today's question. When you have a long text cell, it will tend to spill and show up in adjacent blank cells. David notes that you can add an apostrophe to the blank cell to prevent this. In Episode 677, we take a look at a faster way to solve this problem.
Labels: Blank Cells, GoTo Special Blanks, Wrap Text
posted by Bill at 9:00 AM
When you copy and paste data from a web browser to Excel, a number of maddening settings come along with the data. In Episode 362, I will show you how to turn off the wrap text feature and get the columns wide enough to fit the data.
posted by Bill at 9:00 AM
