Hello everyone, in addition to being the Tiller Evangelist I am also a Google Developer Expert for Google Workspace… which really only means that Google recognizes that I contribute to the developer community.
I saw someone asking for a feature to duplicate rows and columns and I thought that would be easy to create.
I made an UNOFFICIAL ADD-ON for Google Sheets. This means when you run it, you’ll get a scary authorization screen. However, you can see in the code that it only executes on the current spreadsheet and shares no data or access.
Steps
- Open this file and copy the contents.
- In your spreadsheet, go to the Extensions menu and choose “Apps Script.” PASTE the code.
- Name the code “Duplicate” instead of “Untitled Script.”
- Save.
- Run. This is where you’ll be asked to authorize. You are ONLY installing this Add-on to the one spreadsheet you’re pasting the code into.
- Back in your spreadsheet, click on a cell to select a row or column.
- Use the Extensions menu and choose “Duplicate.” You can now select if you want to duplicate the row or column. You can duplicate above, below, top or bottom (or right, left, front, end of sheet)
ENJOY!!
-Alice
Tiller Evangelist
