"How to Edit Cell or Turn Off Editing in Microsoft Excel 2007?"

There are two easy ways to edit cell in a worksheet but before that...

Where do you want to do the editing in your worksheet cells? Excel 2007 allows you to specify if editing should be allowed only in the Formula bar or also in cells.

By default, Excel 2007 allows you to edit the cell information either in the Formula bar or in the cell itself. However, in some cases, you may want to turn the in-cell editing feature off because you want to protect your worksheet cells data being modify!

This tutorial shows you the steps:

To edit the worksheet cells

• Select the cell and press F2 key and start modifying
OR simply double-click on a cell that you wish to modify.
• When finish, just press Enter.

To turn off the cell editing

• Click the Office Button and then click Excel Options button.
• From the Excel Options dialog box displayed, click the Advanced at the left side of the dialog box.

• Under the Editing options section, clear the Allow editing directly in cells check box.
• Click on OK.

Related Topics:

Discovering the Cells Alignment Options in Microsoft Excel 2007
Adding and Editing the Header or Footer in the Excel 2007 Worksheets
How to Merge and Unmerge Cells in Excel 2007?
Formatting Number in Excel 2007

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the edit cell in Excel 2007 info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb