I have seen How to add N more columns? and I'm not satisfied with this solution.

Isn't there a way to specify how many columns to insert above/below a specified column? Why do I need to manually select that many columns to get that option? How else to get an option to insert 20-30 columns without selecting that many.

Any way to make this a shortcut?

  • 1
    The question is unclear. Is it about rows or columns? – Rubén Dec 2 at 15:05
  • @Rubén both. I do not think it matters if it's the case of individual cells, rows or columns. The pain area is that selecting n rows/columns is required to get the option to insert n rows/columns respectively. I find that bad and I want a better solution. – Nick Dec 3 at 2:35

Google Sheets doesn't include a "painless" built-in feature to insert several rows / columns at once but there are some alternatives

  1. Use the macro recorder. You will have to do the "painful" procedure once but after that you could use a menu or custom keyboard shortcut to insert several rows at once.
  2. Use the Google Apps Script editor to customize the recorded macro, i.e. to include a prompt asking for the number of columns / rows to insert and / or to create a custom menu
  3. Use a Google Sheets add-on (if one exists) or create your own.
  • Hi, I like this solution but I am not so technically versed as to write the required code. How exactly do I begin writing my own macro script or building my own extension. A pointer in the direction, on how to begin, would be great. I'm very much open to learn. Thank you! – Nick Dec 5 at 7:05

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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