MS+Excel+accidental+double+clicke

MS Excel accidental double clicker

Have you tried to select or highlight cells, and accidentally double clicked, only to find suddenly that you've made changes to a cell's contents?

If so, you just need to resort to the Undo button or the Esc key to reverse the mistake and then try the cell selection again.

Tired of repeating your work? Do you wish you could stop Excel from allowing the changes right inside the cell? Well it is just a matter of a small change in the Options menu to keep the accidental changes away.

In older versions of Excel, you'll need to use the:- Tools menu, Options choice and then go to the Edit tab.

Untick/check the "Edit directly in cell" choice and click OK.

In Excel 2007, you need the:- Office Button, Excel Options button and then go to the Advance section.

Uncheck/tick the "Allow editing directly in cells" choice and click OK.

Now, when you double click in a cell, the cursor won't insert itself into the data, permitting accidental changes.

Instead, you need to use the formula bar to do your editing, which, let us face it, is an intentional change and should keep the accidental stuff to a minimum.  