Sohu.com Inc. (Sohu) is an online media, search and game service company, which is engaged in providing online products and services on personal computers (PCs) and mobile devices in the People's Republic of China (the PRC). The Company operates through three segments: the Sohu segment; the Sogou segment, and the Changyou segment.
Toggle absolute and relative references. It's much faster and easier than typing $ characters manually. To convert an existing formula, enter cell edit mode, place the cursor in or next to the reference you'd like to convert, then use the shortcut. Note: in Excel 2016 for the Mac, you can also use fn + F4.
Using Absolute and Relative Cell References in Excel Formulas. Excel's absolute cell references, like $A$1, confuse many Excel users. But the explanation is easy. Those dollar signs serve only one purpose. If a dollar sign precedes a row number or column letter, the row or column doesn't change when you copy it. Otherwise, it does change.