# XLSX Print Setup Pack

Apply paper, margins, scaling, repeating titles, and header/footer print settings to Excel workbooks in one pass

> Canonical page: https://elysiatools.com/en/tools/xlsx-print-setup-pack

- **Category:** Format Conversion

- **Keywords:** xlsx, print, page setup, header footer, repeat title rows, exceljs

## Overview

Configure Excel print settings in one run.

- Applies paper size, orientation, margins, and centering
- Supports scaling or fit-to-page width/height
- Repeats title rows/columns on every printed page
- Writes odd-page header/footer text for consistent exports

## Inputs

- **Workbook File** (file)
- **Target Sheets** (text): Sheet1,Sheet2 (blank = all sheets)
- **Paper Size** (select)
- **Orientation** (select)
- **Margins JSON** (textarea): { "top": 0.5, "bottom": 0.5, "left": 0.3, "right": 0.3, "header": 0.2, "footer": 0.2 }
- **Scale Percent** (number)
- **Fit To Width Pages** (number)
- **Fit To Height Pages** (number)
- **Repeat Title Rows** (text): 1:2
- **Repeat Title Columns** (text): A:B
- **Print Area** (text): A1:H60
- **Header Text** (text): &LConfidential&CMonthly Report&RPage &P of &N
- **Footer Text** (text): &LGenerated by Elysia Tools&R&D
- **Center Horizontally** (checkbox)
- **Center Vertically** (checkbox)
- **Print Grid Lines** (checkbox)

## When to use

- Preparing large financial reports or data tables that require consistent headers and footers across every page.
- Standardizing print layouts for multiple sheets within a workbook to ensure uniform margins and orientation.
- Ensuring long data sets fit perfectly on a specific number of pages by applying custom scaling or fit-to-page settings.

## How it works

- Upload your Excel workbook file to the tool.
- Select your preferred paper size, orientation, and define custom margins using the JSON input.
- Specify optional settings like repeating title rows, print areas, or custom header and footer text.
- Process the file to generate a new version of your workbook with all print settings applied.

## Use cases

- Standardizing corporate invoice templates with consistent margins and company headers.
- Formatting complex data exports to ensure column titles repeat on every page for readability.
- Preparing multi-sheet project reports for PDF conversion with uniform orientation and page scaling.

## Frequently asked questions

### Can I apply settings to specific sheets only?

Yes, you can specify individual sheet names in the 'Target Sheets' field, separated by commas.

### How do I repeat header rows on every printed page?

Enter the row range (e.g., '1:2') in the 'Repeat Title Rows' field.

### What format should the margins JSON use?

Use a standard JSON object with keys for top, bottom, left, right, header, and footer, representing inches.

### Does this tool change the actual data in my spreadsheet?

No, this tool only modifies the print metadata and layout settings of the file; your data remains untouched.

### Can I fit my data to a specific page width?

Yes, use the 'Fit To Width Pages' field to force the content to scale to a specific number of pages wide.

## Related tools

- [XLSX Chart Embedder](https://elysiatools.com/en/tools/xlsx-chart-embedder): Embed generated chart images into Excel workbooks using workbook data ranges for bar or pie chart reports
- [XLSX Conditional Formatting Rule](https://elysiatools.com/en/tools/xlsx-conditional-formatting-rule): Batch-apply conditional formatting rules such as threshold highlights, data bars, and color scales to Excel worksheets
- [XLSX Formula Injector](https://elysiatools.com/en/tools/xlsx-formula-injector): Fill formulas down worksheet columns and optionally lock formula cells for protected, template-friendly Excel workbooks
- [XLSX Sheet To JSON Schema](https://elysiatools.com/en/tools/xlsx-sheet-to-json-schema): Infer JSON Schema from worksheet headers and sample rows with types, enum candidates, and basic constraints
- [Time Series Forecast & Seasonality Analyzer](https://elysiatools.com/en/tools/time-series-forecast-seasonality-analyzer): Forecast future periods from CSV or JSON time-series data and inspect trend, seasonal, and residual decomposition in one report
- [XLSX JSON Transformer](https://elysiatools.com/en/tools/xlsx-json-transformer): Bidirectional conversion between JSON arrays and Excel sheets, with nested object flattening and restoration
- [XLSX Parquet Exporter](https://elysiatools.com/en/tools/xlsx-parquet-exporter): Export worksheet data to Parquet and/or NDJSON for data lake and data warehouse pipelines
- [Excel to JSON Converter](https://elysiatools.com/en/tools/excel-to-json): Convert Excel file to JSON format, extracting data from the first worksheet

## Samples

- [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing
- [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests
- [Android Serialization Java Samples](https://elysiatools.com/en/samples/android-serialization-java): Android Java serialization examples including JSON serialization, deserialization, and XML parsing
- [Android Serialization Kotlin Samples](https://elysiatools.com/en/samples/android-serialization-kotlin): Android Kotlin serialization examples including JSON serialization, deserialization, and XML parsing