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

Chapter 3. Formula Annoyances > FORMULA ENTRY AND EDITING ANNOYANCES

FORMULA ENTRY AND EDITING ANNOYANCES

PREVENT COPIED FORMULAS FROM CHANGING CELL REFERENCES

The Annoyance:

I track sales for a department store using the worksheet shown in Figure 3-1. My boss asked me to highlight sales for the jewelry department, so I copied the formula from cell F15 to cell F18—but the formula changed from =SUM(F3:F14) to =SUM(F6:F17). I'm screwed! How do I keep that formula from changing?

Figure 3-1. When you copy this formula from cell F15 to cell F18, it changes to include the wrong cells.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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