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 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.
Form input fields
Menu display language
Language used for the Google app menu and dialog or panel.
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.
Paste Code.gs
Paste the generated Code.gs into Apps Script. Back up existing code before replacing it.
Create BaseSheetDialog.html
Create an HTML file named BaseSheetDialog and paste the generated BaseSheetDialog.html content.
Run initial setup
Select setupLayoutUnifier 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 Layout Unifier menu appears.
Apply the layout
Run Apply row heights and column widths, Apply column widths only, or Apply row heights only from the menu.
Save the implementation guide
After generation, 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.
What the guide includes
The setup method, post-setup review points, generated script, settings JSON, and config hash are collected in one document. The setup method starts with a note that the generated script appears later in the guide.
Available formats
Choose Markdown (.md), Word (.docx), or the PDF save view.
Post-setup review points
Base sheet is saved
Confirm that you can select and save the base sheet from the KOKOCAL Layout Unifier 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.