Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Push a Column to Each Sheet in Google Sheets

Push a Column to Each Sheet in Google Sheets
YouTube video

I had a request by a premium member that they had one Google Sheets spreadsheet with a tab per teacher to keep track of the daily contacts with students and parents. She wanted to add a column each day with the date to each of the sheets for the spreadsheet.

Authorize the Add-on

After making a copy of the spreadsheet wait about a minute for the code to load. Locate the “Add column” menu that shows up next to the help menu. Choose “Authorize Add-on.” I have personally coded this Add-on, it is safe. I have NOT submitted it to Google. If you get a warning that Google has not reviewed it, that would be because I did not ask them to.

Choose “Add”

Choose “Add” from the “Add Column” menu. This will prompt you “What column title would you like to send to each sheet?” Type whatever column header you want to show up on each sheet in your spreadsheet.

2 thoughts on “Push a Column to Each Sheet in Google Sheets

  1. You can also use the IMPORTRANGE command to import a column from the same tab, another tab in the same sheet, or even from another sheet (document) completely.

    Don’t need a separate add-on when there’s already a built-in function…

    1. This would be a bad idea for this application to use import range. You are limited to how many importranges you can use and it loads slower. Also you can’t edit the importranfe values.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.