Skip to main content
Ask Different

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • 1
    I tried removing the return input, and adding in the delays. I also tried the delays at 0.5 just to be thorough. Unfortunately, this had zero impact on my originally reported behavior, aside from the fact that it was a little slower when successfully running it from Automator or the services menu. I also copied and pasted your code block directly into Automator and it still didn't work. This works in every circumstance EXCEPT the keyboard shortcut, but the shortcut DOES result in a cogwheel in the menu, indicating the script is running, plus I get a notification I added as a second step >.> Commented Apr 23, 2020 at 21:11
  • Ok, actually, after giving this some "time" (I hate problems like this)... it seems to be working now, having copied your code directly into mine. Commented Apr 23, 2020 at 21:16
  • Actually, it only works sometimes... and it doesn't appear to be related to frequency. So, I'm now at a complete loss. Now, sometimes it's adding an 'r' character to the cell I have selected. Commented Apr 23, 2020 at 21:20
  • @jtacq You could try editing the shortcuts at Google Sheets (Command+/) and using another combination. The default keys for this action is command+option+shift+= but apparently you will still need two steps. Commented Apr 25, 2020 at 3:15
  • Yeah, when you think about those 2 (awkward) steps in the context of adding 5-10 rows it rapidly becomes a finger traffic jam. Since the key to add a row about is "r", you could remap it to command+option+shift+r, but then you are still stuck with the very awkward action of pressing and releasing command+option+shift alternately. This isn't very repeatable without error. Commented Apr 27, 2020 at 13:08