Learn Excel from Bill Jelen with this daily 2 minute video podcast.
After watching Episode 859, Tom from the U.K. pointed out that the problems go away if you turn off in-cell editing. Episode 874 shows the benefits of turning off in-cell editing.
Labels: Editing
posted by Bill at 9:00 AM
Its two-for-the-price-of-one-Thursday (sounds like we need a new theme...). Question 1: When editing a long formula, the formula covers up adjacent cells, making it difficult to point to those cells with the mouse. Question 2: When you use Shift+Ctrl+Right+Ctrl+Down to select a large range, the Error icon scrolls off the screen. I'll propose solutions to both of these in Episode 859.
Labels: Editing
posted by Bill at 9:00 AM
Donna asked a question at one of my Excel 2007 seminars: There used to be a way in Excel 2003 to prevent the active cell from moving downwards after pressing Enter. In today's Episode 838 - Where Is It Wednesday, I will take a look at how this feature works, where it is in Excel 2007, and how to simulate the feature using a shortcut key.
Labels: Editing, Excel 2007
posted by Bill at 9:00 AM
A quick trick showing how you can make a formula point to a new range without typing the range. Episode 575 shows you how.
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
