Working in Excel 2007. Switched from XP to Vista (not sure if that matters). For some reason, I can no longer edit the contents of a cell by double-clicking. I have to edit in the toolbar. Is there a way to enable/disable the double-click editing function?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cell editing
- Thread starter Pat1979
- Start date
mvptomlinson
Well-known Member
- Joined
- Mar 10, 2008
- Messages
- 2,638
Hi Pat,
Click the Office button (upper left corner) then Excel Options. Select Advanced, then in the settings listed to the right make sure the checkbox for 'Allow editing directly in cells' is checked.
That should do it.
Click the Office button (upper left corner) then Excel Options. Select Advanced, then in the settings listed to the right make sure the checkbox for 'Allow editing directly in cells' is checked.
That should do it.
Upvote
0
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
I would leave that option unchecked - you get no benefits that I can see, and if you have it unchecked and the cell contains a formula that references another cell, double-clicking will take you to that referenced other cell (even in another workbook) which for me is enormously useful.
Upvote
0
