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

Chapter 3. Editing Worksheets > Mixed References

Mixed References

Once you've mastered the concept of relative vs. absolute cell references, consider the third type of reference: a mixed cell reference.

In a mixed cell reference, either the column or row reference is absolute while the other reference remains relative. Thus, you can use cell references like A$1 or $A1. Use this when a column reference must remain constant but a row reference changes or vice versa. Figure 51 shows a good example.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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