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.
Absolute reference is set to Shift+F4 (because F4 is set to Data Sources). This is quite annoying since F4 is the STANDARD key since Lotus 123... You can change this by going to Tools, Customize, Keyboard tab. On the Shortcut keys locate Shift+F4 and press the Delete button. Then navigate to the F4 shortcut and choose Category: Insert, Function: Relative/Absolute References and press the Modify button. You can now set Shift+F4 to Data Source if you wish...