1

In Excel there are some Alt shortcuts like:

  • Alt+E+S+V: paste special value only
  • Alt+I+R: insert a new row

In Google Sheets, they can also be used. When I press Alt+I for example, I see this popup at the bottom:

"Shortcut key pressed: Alt + I"

I know that I can toggle compatible key shortcuts in Google Sheets like this:

Switch: "Enable compatible spreadsheet shortcuts"

With this turned on, I can use the above-mentioned Alt shortcuts however, on some of my computers (Windows 10) turning this option on or off has no effect and the Alt shortcuts listed above cannot be used. There is nothing special about this computer: it's running Windows 10 latest version, latest Chrome.

3
  • 1
    Do you need to pree Alt+Fn?
    – Lee
    Commented Apr 9, 2021 at 7:58
  • Mysterious! I can only guess... region settings, keyboard settings, accessibility settings, account privileges, strange local/group policy about program access to alt buttons?, try run as administrator, try firefox, try another keyboard (laptop vs usb). Weird 32 vs 64 bit issue in compiled chrome binary. Try 32 bit chrome installer. Commented Apr 13, 2021 at 16:04
  • No need for ALt-FN @Lee
    – Freelensia
    Commented Apr 16, 2021 at 2:07

1 Answer 1

0

I found the answer.

LastPass hotkeys were interfering with Google Sheet hotkeys. I don't know how to disable all hotkeys from LP in Chrome. However, you can choose to disable only certain hotkeys.

Right click LP icon and choose Account Options - Extension Preferences. enter image description here enter image description here

Choose Hotkeys. Here you can remove the troublesome hotkey (usually Alt-I) and click Save. enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .