#Google sheets shortcuts insert row below mac#

#Google sheets shortcuts insert row below mac#

Mac users mostly need to replace the Ctrl key with Command (⌘), as well as Alt with Option (⌥), but it’s not a one-size-fits-all method. However, some shortcuts may differ a bit depending on the device you are using. To select a column, you need to press Ctrl+Space, and this shortcut works for PC, Mac, and Chrome OS. To enable the compatible spreadsheet shortcuts, press Ctrl+/ and toggle them on. For example, you can paste transposed only with compatible shortcuts – Alt+h,v,t or Alt+e,s,e. For example, to paste values only, you can use a common shortcut Ctrl+Shift+v, as well as a compatible one – Alt+h,v,v. Some of the compatible shortcuts duplicate the common hotkeys. Note: Compatible spreadsheet shortcuts do not function on Mac. If you enable them, you’ll get 134 additional shortcuts to streamline your workflow. The compatible spreadsheet shortcuts are keyboard shortcuts used in another well known spreadsheet program – Microsoft Excel. What are the compatible spreadsheet shortcuts and how do you enable them?

This is the major hotkey that unfolds all the others you can use.

At the same time, there are plenty of others, which you can explore by pressing Ctrl(⌘)+/. Everyone knows the basic shortcuts, such as Ctrl(⌘)+c to copy, Ctrl(⌘)+v to paste, Ctrl(⌘)+z to undo, and so on. Google Sheets shortcuts are combinations of keys on the keyboard that let you perform specific spreadsheet tasks (navigate, edit, etc.) quickly. To wrap up What are keyboard shortcuts for Google Sheets?