Guide
Spreadsheet Operation Panel Guide
A guide for adding a sidebar operation panel to Google Sheets for quick navigation and range selection.
Actions apply to the active sheet open at the time of execution.
Move the active selection and select ranges without changing values, formulas, or formatting.
Move to the last data row, next empty row, first column, A1, and the used range from the sidebar.
What this generator is for
This generator creates an Apps Script and KOKOCAL_OperationPanel.html file that add a sidebar operation panel to Google Sheets.
It is useful when you often move around large sheets and do not want to rely on memorized keyboard shortcuts.
The generated script does not edit cell values, formulas, or formatting. It changes only the active selection or selected range.
Display language selected on the website
Menu display language
Language used for the Google app menu and dialog or panel.
Sidebar action buttons
Navigation
Move to the last data row, next empty row, last data column, first column, first row, or A1.
Used range
Select the current sheet's used range from the sidebar.
Selection only
The buttons change the active selection but do not edit cell values, formulas, or formatting.
Setup steps
Open Apps Script from Google Sheets
Open the Google Sheets file where you want to add the operation panel, then open Apps Script from Extensions.
Create KOKOCAL_Menu.gs and KOKOCAL_OperationPanel.gs
Create KOKOCAL_Menu.gs and KOKOCAL_OperationPanel.gs in Apps Script, then paste the generated content into each file. Back up existing code before editing it.
Create KOKOCAL_OperationPanel.html
Create an HTML file named KOKOCAL_OperationPanel and paste the generated KOKOCAL_OperationPanel.html content.
Run initial setup
Select KOKOCAL_OperationPanel_setup from the function dropdown and run it manually. Reload the spreadsheet after it finishes.
Open the operation panel
Open the operation panel from the KOKOCAL menu. Actions target the sheet that is currently open.
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
Menu appears
Reload the spreadsheet and confirm that the KOKOCAL menu appears.
Move to the last data row
Confirm that the Last data row button moves to the last data row while keeping the current column.
Move to the next empty row
Confirm that the Next empty row button moves to column A on the row after the last data row.
Column navigation
Confirm that Last data column, First column, Top row, and A1 move as expected on the current sheet.
Select used range
Confirm that Select used range selects the entered range on the current sheet.
Values and formatting stay unchanged
Confirm that values, formulas, and formatting are not changed after using the buttons.
Notes
Selection movement and range selection only
This script assists navigation on the current sheet by moving the selection or selecting the used range. Values, formulas, and formatting are not changed.
Current sheet only
Operation panel buttons target the active sheet at the time of execution. Open another sheet first if you want to operate on it.
Last row and column detection
Last data row and last data column use the range detected by Google Sheets. Ranges that previously had input or formatting may be included.
Back up before use
Before changing order or temporarily hiding objects, make a copy of important slides.
Ready to generate the script
Add a sidebar operation panel for quick navigation to the last data row, next empty row, last data column, first column, A1, and the used range.
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.