"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.
  • Excel 2007 advanced options

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


Related Topics:

How to view, create and freely download the Excel 2007 template files?

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: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.