Excel 2016 (III) Relative and absolute reference, copying a formula




About this tutorial:

Video duration: 00:07:11
Excel tutorial third part. Excel basic math. Basics for beginners in Excel 2016 environment. First steps for the novice Excel users. Basic calculations in MS Excel environment. How to use dollar($) sign in locking the cell. That is called absolute reference compared to relative reference.

I will also explain the difference between locking a cell and then to let the cell to follow formula in copying the cell. Techniques also for how to use fill handle for copying.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads