Jetformat

Freeze the first row or column in Excel

Use jetformat excel freeze to freeze the first row or column in Excel.

By Jetformat

Choose --row, --col, or both. Freeze panes affect navigation in a workbook viewer; they do not add repeated headers to printed PDF pages.

Steps

  1. Start with a local XLSX. Replace the sample paths and identifiers with your own.
  2. Run the command below. Save to a new output path so the source remains available for comparison.
  3. Check the result as described below before using it in another job.
jetformat excel freeze finance.xlsx --sheet Summary --row --col -o finance-updated.xlsx

Options for this task

Option Meaning
--col Freeze the first column
--output Output XLSX path (required)
--row Freeze the first row
--sheet Worksheet name (required)

Check the result

Scroll the saved worksheet in a spreadsheet viewer and confirm the chosen row or column remains visible.

Notes and limits

Writing an Office document uses one credit per command. See the billing guide for the current rules.

The examples keep the original file. Add --force only when you intend to overwrite an existing output. Run jetformat excel freeze --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.

Last updated