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.
This is called the relative reference format, and it's the default format for Excel. This means that if you copy this formula to cell A4, the relative reference is still Multiply the contents of the cell two rows above this one by 2, but the formula changes to. because A2 is two rows above A4. Figure 3.4 shows why this format is useful.