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.
In other words, if you copy the relative formula =A1 to cell B1, Excel updates the reference to reflect the move one column to the right and enters the formula =B1. Copy the formula in cell A1 to A2, and it updates the row reference to =A2. On the other hand, copy the absolute formula =$A$1 to cell B1 or A2 and Excel inserts the same formula, =$A$1. When entering formulas, you can specify an absolute row or column by manually typing the $ sign.