Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

When Are Absolute References Helpful in Excel?

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
18,885
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on May 2, 2007

making a multiplication table in Excel as an exercise to help determine what portions of a cell reference should be made absolute prior to copying the formula.

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 2 dislikes

Link to this comment:

Share to:

Uploader Comments (rrphillips)

  • how did u display the formulas?

  • @joeyhcmc

    CTRL + `

see all

All Comments (15)

Sign In or Sign Up now to post a comment!
  • neat & very clear explanation - thx

  • Thanks for your quick reply...I would like to be an expert in Excel 2007 to be used for contract vs. GL reconciliation. My friend is very good at it and I would like to acquire the same skill in Excel 2007. He knows many short cuts, pivotting, vlookups, etc. Unfortunately he lives in Tunisia and he is working in Bahrain.  In the meantime, I am living in Bangkok, Thailand. Thanks again.

  • thanks alot

  • Thanks phillips ~!!! Your example works on me and i got it right away~!!! I spent 10 minutes reading books and it keep confuse me and you help me out, cheers~!!!

    wish you keep up the good work~!!!

  • how did you make the table

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more