Jetformat

Hide a column in an Excel worksheet

Use jetformat excel hide-column to hide a column in an Excel worksheet.

By Jetformat

Hiding changes display rather than deleting cell data. Keep sensitive values out of a shared workbook instead of relying on a hidden column to protect them.

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 hide-column finance.xlsx --sheet Summary --column A -o finance-updated.xlsx

Options for this task

Option Meaning
--column Column letter, for example A
--output Output XLSX path (required)
--sheet Worksheet name (required)

Check the result

Open the output and confirm the column is hidden; use unhide-column when restoring the view.

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 hide-column --help to compare options with your installed version.

See the excel command reference for the surrounding workflow.

Last updated