You will want to fix, and block some cell addresses so it doesn’t change when you copy the formula. Let’s see how you can do that with a shortcut. This movie is a part of my online course Essential Excel for Management Consultants available with a big discount: bit.ly/EssentialExcelYoutube
Check also my other resources:
1. My playlist on Essential Excel: bit.ly/ExcelPlaylistForU
2. My presentation on Essential Excel: slideshare.net/AsenGyczew/essential-excel-for-business-analysts-and-consultants
3. Most useful Excel functions: badassconsultants.com/2018/10/07/how-to-crush-it-with-excel-practical-guide-for-management-consultants/
- Excel – Absolute references with a shortcut (F4) to fix the cells in Excel ( Download)
- Excel Quick Tip: F4 for Absolute Cell References ( Download)
- Excel Quick Tip: Absolute References with the F4 Key ( Download)
- 5 Must-know Excel Keyboard Shortcuts For The F4 Key ( Download)
- How to Use Absolute Cell Reference in Excel ( Download)
- Absolute Cell Reference Mac user No F4 button ( Download)
- Excel Cell Reference: Absolute, Relative or Mixed ( Download)
- How to lock cells in #excel using F4 ( Download)
- How To Use Relative & Absolute Cell References In Excel ( Download)
- How to use absolute cell reference in formulas | #zohosheet | #shorts ( Download)
- How to Create Absolute References to Columns in Excel Tables ( Download)
- MS Excel - Cell Reference ( Download)
- Excel Shortcut: Repeat Last Shortcut Action with F4 Key ( Download)
- Excel - How to Fix a Fixed Cell Reference Using Absolute and Reference F4 ( Download)
- How to Cell Reference in Excel ( Download)
