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 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.
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 where you want to add the operation panel, 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 OperationPanel.html
Create an HTML file named OperationPanel and paste the generated OperationPanel.html content.
Run initial setup
Select setupOperationPanel 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 Operation Panel menu. Actions target the sheet that is currently open.
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
Menu appears
Reload the spreadsheet and confirm that the KOKOCAL Operation Panel 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.