Categories

← View All Tools

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]" }

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

Key Facts

Category
Format Conversion
Input Types
file, text, number, checkbox, textarea
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The XLSX Freeze Pane Manager is a specialized utility designed to improve the readability of large spreadsheets by automating the application of frozen panes and structured outline groups.

When to Use

  • •When you need to keep headers visible while scrolling through extensive datasets.
  • •When organizing complex reports that require hierarchical row or column grouping.
  • •When preparing wide spreadsheets that benefit from automatically locking the first column for context.

How It Works

  • •Upload your Excel file and specify the target sheet names if you wish to limit the scope.
  • •Define the number of rows and columns to freeze, or enable auto-detection for the first column.
  • •Input your grouping requirements using JSON format to define row and column outline levels.
  • •Select whether to collapse groups by hiding them or keep them expanded in the final output.

Use Cases

Standardizing header visibility across a multi-tab financial report.
Creating collapsible data sections for complex project management trackers.
Improving navigation in wide data exports by locking key identifier columns.

Examples

1. Operations Workbook Optimization

Background
A large operations workbook contains monthly data that is difficult to navigate due to the lack of frozen headers and unorganized data blocks.
Problem
The user needs to keep the top header row visible and group specific data ranges to make the sheet easier to read.
How to Use
Upload the file, set 'Freeze Rows' to 1, and provide the grouping JSON to define the data blocks.
Example Config
[{"from": 2, "to": 15, "level": 1}, {"from": 16, "to": 28, "level": 1}]
Outcome
The first row is locked, and the specified row ranges are organized into collapsible outline groups.

Try with Samples

json, xml, xlsx
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
title token xlsx
xlsx, xls
pnpm Package Manager Samples
Fast, disk space efficient package manager examples including monorepo management, workspace configuration, and advanced workflows
title token manager
json
Web Data Serialization Rust Samples
Web Rust data serialization examples including JSON serialization, deserialization, and XML parsing
preferred input family json
json
Windows Serialization C++ Samples
Windows C++ data serialization examples including JSON serialization/deserialization and XML parsing
preferred input family json
json

Related Hubs

Json Convert Tools
Explore 100 json tools for convert workflows and compare closely related utilities quickly.
Json Tools
Explore 43 json tools for utility workflows and compare closely related utilities quickly.
Json Generate Tools
Explore 33 json tools for generate workflows and compare closely related utilities quickly.
Xml Convert Tools
Explore 32 xml tools for convert workflows and compare closely related utilities quickly.

FAQ

Can I apply different freeze settings to different sheets?

Yes, you can specify target sheet names to apply unique configurations to specific tabs within your workbook.

What is the purpose of the 'Auto Freeze First Column' option?

It automatically locks the first column of your sheet if the total column count exceeds your defined minimum threshold, ensuring context remains visible.

How do I define row or column groups?

Use the Row Groups JSON or Column Groups JSON fields to provide an array of objects specifying the 'from' index, 'to' index, and the 'level' of the group.

What happens when 'Collapse Groups By Hiding' is enabled?

The tool will hide the rows or columns defined in your groups, effectively collapsing the outline levels in the exported file.

Does this tool support both .xlsx and .xls files?

Yes, the tool supports standard OpenXML spreadsheet formats including .xlsx and .xls.

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]