Spreadsheet Tips

Enable Excel shortcuts in Google Sheets

November 12, 2019
A person using Google Sheets enables a preference for Excel compatible shortcuts, and then uses one of them.

One problem with Google Sheets is that there are subtle differences between it and Excel. This can be a frustrating experience for those who are more familiar with Excel.

One way to reduce the differences is to enable Excel compatible keyboard shortcuts. This makes it so most of the keyboard shortcuts that work for Excel will also work for Google Sheets.

To do this, got to the Help menu in Google Sheets, select Keyboard Shortcuts, and toggle the "Enable compatible spreadsheet shortcuts option". You can then browse the list of shortcuts to see which new ones were enabled.