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.
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I got a note today from Tom.
Tom's in the UK.
He was talking about Episode 859.
Back in Episode 859, I kind of lamented the fact that if we choose a cell and press F2 to edit that cell, it overwrites the cell to the right; so that means that we can't rewrite the formula just by grabbing that box to the right because we can't really see very well, the box to the right.
And Tom said, "You know, there's a way to turn this off," and Tom is absolutely right.
If we go to Tools, Options, and then on the Edit tab, there's something called "Edit directly in cell"; and if you turn off in cell editing, now when you press the F2 key, you're expected to edit up here in the formula bar, and it doesn't overwrite the adjacent cell.
Also, Tom points out, that if you double-click the cell, what it's going to do now, is choose all of the precedents right on the current sheet, so we can format those precedents and, you know, kind of, as we did in another recent podcast using Edit, Go to Special Precedents.
So this is a cool thing.
And if it really bugs you having the formula there, you could turn off in cell editing.
Now, for me, I really have gotten used to in cell editing-- I like to be able to edit right down there on the sheet, you know.
I realized 10 years ago we all did all of our editing up in the formula bar, but I've just gotten used to it and it's hard for me to bite the bullet and turn this off.
Alright, I want to thank Tom for sending in a note, and certainly a great way to go is to turn off that setting, which is under Tools, Options, and then Edit to turn off Eedit directly in cell".
There you have it.
Thanks for stopping by, I'll see you next time for another netcast from MrExcel.
I got a note today from Tom.
Tom's in the UK.
He was talking about Episode 859.
Back in Episode 859, I kind of lamented the fact that if we choose a cell and press F2 to edit that cell, it overwrites the cell to the right; so that means that we can't rewrite the formula just by grabbing that box to the right because we can't really see very well, the box to the right.
And Tom said, "You know, there's a way to turn this off," and Tom is absolutely right.
If we go to Tools, Options, and then on the Edit tab, there's something called "Edit directly in cell"; and if you turn off in cell editing, now when you press the F2 key, you're expected to edit up here in the formula bar, and it doesn't overwrite the adjacent cell.
Also, Tom points out, that if you double-click the cell, what it's going to do now, is choose all of the precedents right on the current sheet, so we can format those precedents and, you know, kind of, as we did in another recent podcast using Edit, Go to Special Precedents.
So this is a cool thing.
And if it really bugs you having the formula there, you could turn off in cell editing.
Now, for me, I really have gotten used to in cell editing-- I like to be able to edit right down there on the sheet, you know.
I realized 10 years ago we all did all of our editing up in the formula bar, but I've just gotten used to it and it's hard for me to bite the bullet and turn this off.
Alright, I want to thank Tom for sending in a note, and certainly a great way to go is to turn off that setting, which is under Tools, Options, and then Edit to turn off Eedit directly in cell".
There you have it.
Thanks for stopping by, I'll see you next time for another netcast from MrExcel.
