Printing Problems

How to Print One Excel Cell on a 45x15mm Zebra Label

John WilsonJohn Wilson Nov 11, 2026 869 views

Question details

The user needs to print the contents of a single spreadsheet cell precisely onto a small 45 by 15 mm physical label using a Zebra thermal printer.

How to Print One Excel Cell on a 45x15mm Zebra Label
Product
Excel
Device & OS
not provided
Scenario
Creating custom small labels by outputting a specific cell's data onto 45x15mm label stock through a dedicated label printer.
Observed behavior
To achieve accurate alignment without clipping, the software's cell dimensions, print area, paper size, and the printer's hardware driver settings must all be synchronized to the label's physical size.
Before you start

Ensure your Zebra printer is properly connected, the 45x15mm label roll is securely loaded, and the correct Zebra printer drivers are installed on your computer.

Solution 1Recommended

Configure Print Area and Custom Paper Size

Set the exact print area in your spreadsheet and match the page setup to the Zebra label dimensions.

Printing onto small thermal labels requires precise page setup. By isolating a single cell as the print area and defining a custom paper size, you prevent the printer from attempting to output a full standard-sized sheet onto a tiny label.

1
Set Cell Dimensions

Adjust the row height and column width of your target cell (e.g., cell B5) to roughly match the physical 45 x 15 mm proportions so your text wraps correctly.

2
Define the Print Area

Select the cell you want to print. Navigate to the 'Page Layout' tab on the top ribbon, click 'Print Area', and select 'Set Print Area'.

3
Configure Page Size and Margins

Open the Page Setup dialog. Set a custom paper size of 45 mm (width) by 15 mm (height). Under the Margins tab, set all page margins to 0 (or the printer's minimum), and adjust scaling to 'Fit to 1 page'.

4
Adjust Printer Driver Settings

Open the print dialog by pressing Ctrl + P and select your Zebra printer. Click on 'Printer Properties' or 'Preferences' and verify the label stock size is exactly 45 x 15 mm.

5
Preview and Test Print

Check the Print Preview to ensure the cell contents fit the label boundaries perfectly. Print a single test label to verify alignment before printing any batches.

Configure Print Area and Custom Paper Size
Calibration Tip: If the printer feeds blank labels after printing, recalibrate the Zebra printer hardware to recognize the gaps between the 15mm labels.
Efficient Spreadsheet Printing

Print Custom Labels Easily with WPS Spreadsheet

WPS Spreadsheet provides precise page setup controls and custom margin settings, making it incredibly simple to align data for specialty media like Zebra thermal labels.

  1. 1. Select the Cell: Highlight the specific cell containing your label data in WPS Spreadsheet.
  2. 2. Set Print Area: Go to the Page Layout tab on the ribbon and click Print Area > Set Print Area.
  3. 3. Adjust Page Setup: Click the Page Setup dialog launcher, select Custom Size, enter 45mm x 15mm, and set all margins to zero.
  4. 4. Print to Zebra: Press Ctrl+P, select your Zebra printer from the drop-down list, confirm the label size in Printer Properties, and click Print.
Precise custom page layout sizes for specialized thermal labelsFully compatible with Microsoft Excel (.xlsx) formatsIntuitive Print Preview ensures accurate alignment before printingLightweight, free to download, and easy to use
microsoft office alternative - wps office

Frequently Asked Questions

Why is my printed text misaligned or cut off on the label?

This usually happens if the printer driver's label size does not match the page setup size in your spreadsheet. Ensure both the spreadsheet's custom page size and the Zebra printer hardware preferences are set to exactly 45 x 15 mm.

How do I change the measurement units to millimeters in my spreadsheet?

To set your software to millimeters, go to Options > Advanced, scroll down to the Display section, and change the 'Ruler units' drop-down menu to Millimeters.

Can I print multiple consecutive labels from different cells?

Yes, you can format a single column where each cell represents one label. Set the page size for one 45x15mm label and print the entire column; the printer will automatically feed a new label for each cell at the page break.