Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

Excel: Absolute & Relative Cell Addressing

Excel Excel: Absolute & Relative Cell AddressingExcel: Absolute/Relative Referencing

How to glue a cell in place within Excel

With the basics of formulas and functions covered, you are going to need to copy these calculations across your Excel spreadsheet multiple times. All well and good until you may notice that in some cases the Excel formula isn’t copying properly.  Ever had a formula that when copied either comes up with an error or completley the wrong answer? If the answer is “yes” then this is probably down to Absolute & Relative cell referencing.

Before you suddenly get cold shivers down your back and are running for the nearest exist, I assure you its not complicated, its something you need to understand and within a few minutes you will only need to have one forumula which can be copied over thousands of Excel cells without the needing to adjust.

By watching this video you will be able to understand what Absolute Versus relative cell referencing in Excel is and how to control it to your bidding!

This video is one of many Excel tutorials on this site click here for more.

Example Excel File

This video comprises of an example file that can be obtained here: [/blockquote_left]

Related Posts

9 Comments

  1. PCTeachME says
    07 Aug 11 at 4:10pm

    thanks

  2. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

  3. TheGeshe says
    28 Nov 10 at 11:00pm

    [..YouTube..] awesome video..thanks for the upload….:D

  4. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

  5. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

  6. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

  7. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

  8. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

  9. TheGeshe says
    28 Nov 10 at 11:00pm

    awesome video..thanks for the upload….:D

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security