XLSX Freeze Pane Manager

Freeze top rows/left columns automatically and apply row or column outline groups for easier spreadsheet reading

Improve workbook readability for large tables. - Freezes top rows on selected worksheets - Auto-freezes the first column when the sheet is wide enough - Applies row and column outline groups from JSON ranges - Supports collapsed-style exports by hiding grouped ranges

Example Results

1 examples

Freeze Headers and Add Outline Groups

Freeze the first row, auto-freeze the first column, and create row/column outline groups for a large operations workbook

xlsx-freeze-pane-manager-example1.xlsx View File

View input parameters

{ "workbookFile": "/public/samples/xlsx/ops-source.xlsx", "freezeRows": 1, "freezeColumns": 0, "autoDetectFirstColumn": true, "minColumnsForAutoFreeze": 8, "rowGroupsJson": "[\n {\n \"from\": 2,\n \"to\": 15,\n \"level\": 1\n },\n {\n \"from\": 16,\n \"to\": 28,\n \"level\": 1\n }\n]", "columnGroupsJson": "[\n {\n \"from\": 3,\n \"to\": 8,\n \"level\": 1\n }\n]" }

Workbook File *

Click to upload file or drag and drop file here

Maximum file size: 200MB Supported formats: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel

Target Sheets

Freeze Rows

Freeze Columns

Auto Freeze First Column

Min Columns For Auto Freeze

Row Groups JSON

Column Groups JSON

Collapse Groups By Hiding

Summary Below

Summary Right

API Documentation

Request Endpoint

POST /en/api/tools/xlsx-freeze-pane-manager

Request Parameters

Parameter Name	Type	Required	Description
workbookFile	file (Upload required)	Yes	-
sheetNames	text	No	-
freezeRows	number	No	-
freezeColumns	number	No	-
autoDetectFirstColumn	checkbox	No	-
minColumnsForAutoFreeze	number	No	-
rowGroupsJson	textarea	No	-
columnGroupsJson	textarea	No	-
collapseGroups	checkbox	No	-
summaryBelow	checkbox	No	-
summaryRight	checkbox	No	-

File type parameters need to be uploaded first via POST /upload/xlsx-freeze-pane-manager to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}

File: File

AI MCP Documentation

Add this tool to your MCP server configuration:

{
  "mcpServers": {
    "elysiatools-xlsx-freeze-pane-manager": {
      "name": "xlsx-freeze-pane-manager",
      "description": "Freeze top rows/left columns automatically and apply row or column outline groups for easier spreadsheet reading",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=xlsx-freeze-pane-manager",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]

Categories