Guide
Spreadsheet Layout Unification Guide
A guide for applying row heights and column widths from a selected base sheet to other sheets in the same Google Sheets file.
Choose the base sheet from an in-spreadsheet menu after setup.
Apply row heights and column widths without changing values, formulas, or cell formatting.
Use only rows and columns that already exist in each destination sheet.
What this generator is for
This generator creates an Apps Script and KOKOCAL_LayoutUnifier_BaseSheetDialog.html file that unify spreadsheet layout dimensions.
It is useful when multiple sheets in the same file should share the same row heights and column widths.
The script does not add or delete rows or columns, and it does not change cell values, formulas, or formatting.
Display language selected on the website
Menu display language
Language used for the Google app menu and dialog or panel.
Base sheet and added menu after setup
Base sheet selection
Choose the sheet whose row heights and column widths should be used as the standard.
Apply layout
Apply dimensions to selected destination sheets without changing values, formulas, or formatting.
Existing ranges only
The script uses rows and columns that already exist in each destination sheet.
Setup steps
Open Apps Script from Google Sheets
Open the Google Sheets file whose layout you want to unify, then open Apps Script from Extensions.
Create KOKOCAL_Menu.gs and KOKOCAL_LayoutUnifier.gs
Create KOKOCAL_Menu.gs and KOKOCAL_LayoutUnifier.gs in Apps Script, then paste the generated content into each file. Back up existing code before editing it.
Create KOKOCAL_LayoutUnifier_BaseSheetDialog.html
Create an HTML file named KOKOCAL_LayoutUnifier_BaseSheetDialog and paste the generated KOKOCAL_LayoutUnifier_BaseSheetDialog.html content.
Run initial setup
Select KOKOCAL_LayoutUnifier_setup from the function dropdown and run it manually. A base sheet selection dialog will open.
Select the base sheet
Choose the sheet whose row heights and column widths should be used as the base, then save it.
Reload the spreadsheet
Reload Google Sheets so the KOKOCAL menu appears.
Apply the layout
Run Apply row heights and column widths, Apply column widths only, or Apply row heights only from the KOKOCAL menu.
Save the implementation guide
After generating the script, use Download setup guide at the top right of the generated result column to save the information needed for setup. Generated results disappear when you leave the page, so saving the guide before setup is recommended.
Post-setup review points
Base sheet is saved
Confirm that you can select and save the base sheet from the KOKOCAL menu.
Column widths are applied
Change column widths on the base sheet and confirm that the column-width-only command applies them to other sheets.
Row heights are applied
Change row heights on the base sheet and confirm that the row-height-only command applies them to other sheets.
Values and formulas stay unchanged
Confirm that cell values, formulas, and cell formatting are not changed after applying the layout.
Row and column counts stay unchanged
Confirm that rows and columns are not added or deleted even when target sheets have fewer rows or columns than the base sheet.
Notes
Important note
Review this point before using the generated script in production.
Important note
Review this point before using the generated script in production.
Review before use
Review this point before using the generated script in production.
Back up before use
Before changing order or temporarily hiding objects, make a copy of important slides.
Ready to generate the script
Apply row heights and column widths from a selected base sheet to other sheets in the same spreadsheet.
Guide
Related guides
Review these guides together with this page to make setup and operation smoother.
Getting started
Review the input column, generated result column, code, setup steps, review points, and JSON menu.
Apps Script basics
Review .gs files, HTML files, saving, first authorization, triggers, and other basics before setup.
Using multiple scripts
Learn how to organize KOKOCAL_Menu.gs, feature files, the shared menu, triggers, and permissions when combining generated scripts.