Excel Forum
Similar Content
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Top Excel Keyboard Shortcuts to Increase Productivity
Tutorial: I'll show you the top keyboard shortcuts for Excel that are sure to increase your producti...
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...



Excel Basics #8: Cell References Relative & Absolute


The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#8 Video topics:
1)Cell references in formulas
2)F4 key to select the type of cell reference
3)Relative Cell Reference
4)Absolute Cell Reference
5)Mixed Cell Reference with column locked (Absolute Column)
6)Mixed Cell Reference with row locked (Absolute Row)
7)Fill handle double click trick for copying
8)Ctrl + Enter keyboard shortcut for entering many formulas at once
9)Formula for Percentage
10)Formula for periodic increase (increase each successive amount by 10%)
11)Formula function for Future Value





Got a Question? Ask it Here in the Forum.