Here's our Microsoft Office Tip for.. March 15, 2005
Click Here to see a complete list of all of our previously released Tips!
Double-Click's a Bust
When you double-click a cell, Excel opens that cell in Edit mode. This may or may not be a problem for you. If you find users inadvertently double-click and destroy data in Edit mode without realizing what they're doing, it's a problem for you.
Fortunately, you can inhibit this behavior. Choose Tools, Options, then click the Edit tab. Next, deselect the Edit Directly In Cell option. Then, click OK to return to your worksheet. The next time someone double-clicks a cell, Excel will just select the cell.