Topics

Apr 8, 2011

Enable or disable editing directly in cells in Excel 2007

By default, you can edit directly in cells. You can enable or disable editing directly in cells by changing an Excel option. Perform the following steps to do so:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Editing options, do one of the following:
a. To edit directly in cells: Click to place a check mark besides Allow editing directly in cells.
b. To disable editing directly in cells: Click to remove the check mark besides Allow editing directly in cells.
5. Click OK.

0 comments:

Post a Comment