For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Office 2016 for Mac. Microsoft Excel – Mac keyboard shortcut for absolute cell references. There are many Excel keyboard shortcuts, but we focus here only on those you might actually use regularly. Use keyboard shortcuts in Google Sheets to navigate, format, and use formulas. Learn the Excel keyboard shortcuts (MAC and PC) to switch tabs (worksheets).
This still works in the Mac world if I enter it manually, but in the Windows version of Excel, there was a keyboard shortcut (highlight A1 in the formula bar and then press the F4 button) which would put the $ signs in for you.
