About This Shortcut
This shortcut will accept a function suggested by autocomplete. Start typing the first few letters of a function, then type Tab to accept the top option in the list that appears. You can also use up or down arrow keys to navigate the autocomplete list before pressing Tab.
About This Shortcut
This shortcut will display the Insert dialog box. If an entire row or entire column is selected, this shortcut will insert a new row or new column.
Note: In Mac Excel 365, the Control key can be substituted for the Command key. Before Mac Excel 2016, this shortcut was Control + I.
