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 Excel 2013 and resent versions, you can use F2 and F4 to speed things up when you want to toggle the lock. About the keys: F2 - With a cell selected, it places the cell in formula edit mode. F4 - Toggles the cell reference lock (the $ signs). Example scenario with 'A4'. Pressing F4 will convert 'A4' into '$A$4' Pressing F4 again converts '$A$4' into 'A$4'