Welcome toExcel2007.Tips.Net
Helpful Links
Family Tips
Gardening Tips
Pet Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Specifying where Editing is Done
Summary: Where do you want to do the editing in your worksheet cells? Excel allows you to specify if editing should be allowed only in the Formula bar or also in cells.By default, Excel allows you to edit cell information either in the Formula bar or in the cell itself. (Select the cell and press F2, or simply double-click on a cell.) You may want to turn the in-cell editing feature off, however. To do this, you can follow these steps:
- Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- Click Advanced at the left side of the dialog box. (Click here to see a related figure.)
- In the Editing Options section, clear the Allow Editing Directly in Cells check box.
- Click on OK.
Related Tips:
Tremendous Table Tips! We often take tables for granted, but Word includes some very powerful ways you can present your tabular data. Discover how to make your tables better, easier to understand, and more effective. Check out WordTips: Terrific Tables today!