Home > Mobile >  How to pin a common column on all the sheets
How to pin a common column on all the sheets

Time:11-13

I am building a google sheet spanning multiple sheets. I have an index page with hyperlinks to few select sheets for convenience. I'm looking to pin this column to show up on all the sheets.

Most suggestions I found online is about copying over the column from index page to all sheets, which I find hard to maintain and scale.

Is there a better way to achieve this?


CodePudding user response:

Suggestion:

Perhaps you can enter image description here

Wish List

enter image description here

Laptops

enter image description here

Apparel

enter image description here

Reference:

Google Apps Script

Apps Script: setFrozenColumns(columns)

  • Related