• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Editing Cell Contents

You can use the formula bar to edit the contents of a selected cell, or you can perform your editing “on location” in the cell itself. Excel also includes a few special features you can apply to tasks such as entering date sequences, which once used to involve editing each cell but are now semiautomatic, if you know where to find the “trigger.”

Editing in the Formula Bar

You can also use Cut, Copy, Paste, and Clear to edit entries using the formula bar. Often, simply reentering a value or formula is easier, but the Edit menu options are convenient when you're working with a long, complex formula or label. These options work just as they do in a word-processing program such as Word when you're working in the formula bar. For example, you can copy all or part of a formula from one cell to another. For example, suppose cell A10 contains the formula =IF(NPV(.15,A1:A9)>0,A11,A12), and you want to enter =NPV(.15,A1:A9) in cell B10.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint