Lesson 3-12 from: Microsoft Excel 2013 Essential Skills (147 Video Lessons)

Quality

LOW

Captions

OFF
Transcript

OFF

Speed

1x

Understand absolute and relative cell references

Play The Video

ExcelCentral.com

Play

Back 10 Seconds

Slower

Faster

Full Screen View

Online Video Course: | Microsoft Excel 2013 Essential Skills | |
---|---|---|

Session: | Session 3: Taking Your Skills To The Next Level | |

Lesson: | Lesson 3-12 Understand absolute and relative cell references | |

Description: |
Excel Absolute and relative cell references are extensively covered in this Excel 2013 video lesson. You will often want to add absolute cell references to Excel formulas when you do not want Excel to adjust them. Making them absolute will freeze the cell reference within your Excel formula. you'll create absolute Excel cell references by adding a dollar sign ($) in front of the letters and numbers in a cell reference and then learn how to do this automatically using a hotkey. |