All Courses
AI Career Planner
1:1 Coaching/Mentoring
Job Board
SQL
HTML/CSS/JS
Coding
Settings
LogoutMixed Reference is a type of Absolute reference in which either the column is made constant or the row is made constant. When we make any column or row constant then the column name or row number does not change as we copy the formula to other cell(s). The mixed reference is designated by a dollar sign($) in front of the row or column. For example:
$F1: In this the column F is constant.
F$1: In this the row 1 is constant.