When you copy a formula in Excel, it automatically changes the formula to work for the underlying or adjacent cells. But sometimes you are referring to a cell or range in a formula that must stay static when being copied. This video shows you how to use absolute cell referencing to lock certain cells or ranges in a formula.

#MrLongEducation #Excel #AbsoluteReferencing

свернуть