If you connect an external keyboard to your Android or iOS device, you’ll also be able to use a limited number of Google Sheets hotkeys (how many may depend on the keyboard and language you use). Spreadsheet shortcuts on Android and iPhone/iPad For example, it works for the Insert time shortcut:īut to Format as time, you can use the PC shortcut on your Mac without any changes:Ĭheck out this spreadsheet with a detailed list of shortcuts for PC, Mac, and Chrome OS in one table. 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?

Quick text paste alternative