I would like to know if it would be possible to toggle the different features in sheets with a script.

What I am trying to do is to basically create a button that will show the Named Ranges side panel without having to go Data > Named Ranges.

How can I script this?


1 Answer 1


Per @Rubén's comment, it doesn't appear possible to call up interface items in the way you describe.

However, you can make use of the native keyboard shortcuts.

To get to Named Ranges on a PC:

  1. In Google Chrome: Alt + d. Other browsers: Alt + Shift + d
  2. Press n.

On a Mac:

  1. Ctrl + Option + d
  2. Press n.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.