MS Excel | Absolute Cell Referencing

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

• #education
• #mister_long
• #mr_long
• #mister_long_education
• #cat
• #computer_application_technology
• #grade_12
• #microsoft
• #excel
• #ms_excel
• #computers
• #spreadsheets
• #caps
• #grade_11
• #absolute
• #absolute_cell
• #absolute_cell_referencing
• #cell_reference
• #cell_referencing
• #absolute_referencing
• #static
• #lock
• #dollar
• #dollar_symbol
• #f4