# XLSX Print Setup Pack

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

> Canonical page: https://test.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://test.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://test.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://test.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://test.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://test.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://test.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://test.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://test.elysiatools.com/en/tools/excel-to-json): Convert Excel file to JSON format, extracting data from the first worksheet

## Samples

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

## Related content

- [Professional Assembly of an Excel Workbook](https://test.elysiatools.com/en/hubs/xlsx-workbook-professional-assembly): Furnish a bare spreadsheet into a workbook people can use without asking you questions — upgrade the legacy file, fill formulas down with the cells locked, name the ranges, gate inputs with validation dropdowns, let conditional formatting flag outliers, freeze the headers, build the index sheet, and set the workbook up to print.
