How to generate barcodes with specified image size (width, height)
in Excel?

Generate, create 1d and 2d barcode images with target dimension size in Office Excel

How to create, print barcodes with target dimension width, height in Excel document with free online user guide?

In this page, you will learn how to generate, print QR Code and barcodes with specified width and height using Excel Barcode Generator add-in freeware.

Create, draw square barcode symbols (QR Code and Data Matrix) in specified square size in Microsoft Excel 365, 2021, 2019 applications
Precisely control the printed barcode width and height by inputing the image size value in "Barcode Settings" pane
Adjust barcode bar/space modules automatically or manually in target image regions in Excel
Free distribute the Excel file with barcode printed without barcode add-in, barcode font, activex programming code installed

How to resize barcode image width & height in Microsoft Excel Worksheet?

Download Barcode Generator Excel Add-in freeware
Install Excel add in to generate linear, 2d barcodes with specified dimension size in Excel sheet
Step by Step Tutorial

How to quickly create barcode with specified image width & height?

You can easily create, adjust, print barcode with your target image width and height in Excel file.

Select the Code 128 barcode you need adjust its image width and height
In Image width and Image height text box, key in your target image width & height. By default the values are in pixels, you can change it to other unit of measure, such as Inch or CM
Click Update button to apply the changes.

Note: make sure Auto resize option is checked. It indicates the barcode add-in will calculate and print the maximum size of bar module for the generated barcode.

QR Code and Data Matrix width and height adjust

For square barcodes, such as QR Code and Data Matrix, you need input the same size of Image width and Image height.

Barcode Size Options in Excel Barcode Generator Add-in

You can easily custumize the generated barcode dimension size (width and height) through barcode size options in the Barcode Settings pane in Excel.

Open OnBarcode Barcode Generator Excel add-in in Excel Add-ins toolbar, you will find all barcode size ralated option settings under the tab "Barcode Size"

List of barcode size options:

Unit of Measure. Choose one of the options PIXEL, INCH, or CM.
DPI. Barcode image resolution value in dots per inch.
Auto resize. If checked, barcode generator software will automatically calculate the maximum X and Y module based on Image width and Image height. Option Bar width (X) and Bar height (Y) will be disabled.
Auto resize barcode text. For 1d barcodes only. If the option is checked, the barcode text label will be automatically printed by the barcode Add-in. If you need manually adjust the text font size, you should uncheck the option.
Bar width (X). Barcode bar module width.
Bar height (Y). Barcode bar module height. For matrix barcodes (QR Code and Data Matrix), this option will be automatically disabled. The bar height should be the same value as bar width.
Image width. The generated barcode image width.
Image height. The generated barcode image height.
Left margin. Barcode left margin value.
Right margin. Barcode right margin value.
Top margin. Barcode top margin value.
Bottom margin. Barcode bottom margin value.
Text margin. For 1D (linear) barcodes only, the margin space between barcode and HRI (Human Readable Interpretation)
Rotate. Barcode rotation angles, in 0, 90, 180, 270 degrees.

The following options are applicable for some barcode symbologies only.

Bearer bar (Horizontal). For ITF-14 barcode only. ITF-14 horizontal bearer bar size vs bar module (X) size ratio
Bearer bar (Vertical). For ITF-14 barcode only. ITF-14 vertical bearer bar size vs bar module (X) size ratio
Wide to narrow bar ratio. For Code 39, Code 93, IDENTCODE, Interleaved 2 of 5, ITF-14, LEITCODE, MSI Plessery only, Wide Narrow bar Ratio. Valid value is from 2.0 to 3.0 inclusive.
Short to tall bar. For PLANET, POSTNET, Short bar vs high bar ratio.
I. For Code 39 only, width of intercharacter gap. The minimum value is the bar width (X).

How to generate, print 2d barcode with specified dimension size in Excel file?

Here we will introduce several methods to create, print 2d barcode with specified image size (width and height) in Microsoft Office Excel document.

Method 1: Click and drag the corners to resize the barcode

To change an existing barcode in Excel sheet, you can select the barcode image. Drag and drop to change the image width and height.

Here are the detailed steps to resize a barcode image through drag and drop on Excel document.

Select the target QR Code barcode image. Use the bouning box handles to resize the barcode image.

After resizing the barcode image, you need click the image again. Now the barcode property setting panel will display the new resized image width and height values.

Press button "Update" to re-paint the QR Code barcode image. You will find the QR Code Bar width (X) has been updated to the previous size.

To draw the QR Code barcode with largest module size to fit the new barcode image area, you need check property "Auto resize", and press button "Update" again.

Now the resized QR Code barcode has been re-painted with largest bar module size.

Method 2: Image Width and Height Settings in Property Panel

You can also change the barcode image width and height values in Barcode Settings panel directly.

Here are the steps to follow:

Select the target barcode image

Change the image width and height values to 703 pixels.
Check the property "Auto resize".
Click button "Update".

How to create, adjust barcode elements size in Excel?

We have already known how to create and print a barcode within a specified area (rectangle) in Microsoft Excel document.

In the following section, we will show you how to customize the barcode elements size using Excel Barcode Generator Add-in.

Barcode bar and space module (usually black and white module) width and height
ISO specification or industry standard required minimum quiet zone size
Image margins around the barcode
Image padding area

How to create barcode with bar / space module size customized?

By default, once you have specified the barcode image width and height, the barcode generator add-in will calculate the maximum bar and space module size for you.

However you can still create and print barcode with specified bar and space module size.

In the following guide, we have open an Excel document with a QR Code (width and height both are 650 pixels) generated on cell B2

Uncheck option "Auto resize".
Input 10 pixels for both "Bar width (X)" and "Bar height (Y)".
Click button Update to re-print the QR Code on Excel cell.

Now you will find that the updated QR Code image width and height are still in 650 pixels. And the bar and space modules are in 10 pixels.

How to create barcode in Excel with minimum quiet zone and image margins applied?

Some barcode symbologies (such as Code 128) have defined their minimum quiet zones for good scanning conditions. For example, Code 128 minimum quiet zone is 10X (X is the barcode bar module width).

By default, the Excel barcode generator add-in will automatically insert a leading quiet zone and a trailing quiet zone in Code 128 barcode.

You can easily remove them from barcode using barcode freeware. Here is a Code 128 with quiet zone appended in Excel application.

Select the Code 128 barcode on cell B2
Find the option "Apply min quiet zones" in tab "1D Barcode", uncheck it.
Click "Update" button to re-draw the Code 128 barcode without quiet zones

Here you get a new Code 128 barcode with quiet zones removed (the bar module width become larger).

How to print barcode with transparent padding area in Excel?

After you have specified the barcode image width and height, ususally there are some extra space cannot be printed for bar and space modules. These space colors are the same as the barcode space color.

You can make these extra padding color to transparent color, so that the users will ignore it.

Select the QR Code in Excel
Uncheck the Is padding area transparent option under tab "Barcode Size"
Click "Update" button to re-paint QR Code image on Excel

Now you will find that the padding area surrounding the QR Code is transparent.

How to create linear barcode with specified dimension size in Excel file?

The linear barcodes (such as Code 39, Code 128, EAN/UPC) include not only bar modules, also include barcode text (human-readable interpretation, aslo known as HRI).

When you are resizing linear barcodes, you also need change barcode text size and the space between bar code and text displayed.

Create and draw linear barcodes in specified area in Excel file

Here are the steps:

Create a new Code 128 barcode in Excel. Apply the following property settings:

Image width to 600
Image height to 450
Check property "Auto resize"

Now we need change the displayed barcode text font size.

Go to tab "1D Barcode", change font size to 18

Last step, we need increase the space between bar code and displayed barcode text.

Go to tab "Barcode Size", change Text margin to 24

Conclusion

In this article, we have learned how to resize the 2d barcodes and linear barcodes with barcode properties adjusted in Office Excel document. And we also have learned how to customize the barcode elements' size, such as bar/space width, margin size in Excel.

Frequently Asked Questions

What is the barcodes default size?

The barcode add-in does not provide a fixed size for all barcode formats. For each barcode format, the barcode generator add-in will provide a fixed default width and height.

What happens if the specified image width, height for a barcode are too small?

If the specified image size (width & height) are too small, the barcode add-in will increase the generated barcode image minimum width and height.

To reduce the barcode space, can I do not print barcode text label under barcode in Excel?

Yes. You can hide the 1d barcode text label below the barcode modules.

Find the property "Display barcode text" from "Barcode Settings" pane > "1D Barcode" tab > "Barcode text style" group. Uncheck the option to hide the barcode text.

Can I specify a barcode image width and height in inch?

Yes. You can choose one of the three unit of measure for generated barcode in Excel. Pixel (default), Inch and CM.

To change the barcode unit of measure, find the tab "Barcode Size". Select one of the three options in drop down list "Unit of Measure".

Can I specify a minimum bar module (X) width to the barcode in Excel?

You can specifity the bar module (X) width value using barcode add-in. Find the "Barcode Size" tab in the "Barcode Settings" pane.

1) Uncheck option "Auto resize" in group "Width & Height".
2) Specify the bar module width in option "Bar width (X)"

To reduce the barcode space, can I remove the barcode margins and quiet zones around it?

Yes. You can remove image margins and barcode minimum quiet zones around the barcode in Excel.

To remove barcode image margins, find the "Margin & Retation" group in tab "Barcode Size". Set the four options "Left margin", "Right margin", "Top margin", "Bottom margin" values to 0.

To remove the barcode minimum quiet zones, find "Basic Properties" group in tab "1D Barcode". Uncheck option "Apply min quiet zones".

Why the resized barcode image has been automatically updated to the original image size?

If you try to use the bouning box handles to resize the selected barcode image width and height, you need click the barcode image again, and make sure the "Image width" and "Image height" have updated the resized values in "Barcode Settings" pane.

Now you can click "Update" button to re-draw the barcode to the resized image area.

In this page

Start with free add-in:

How to generate barcodes with specified image size (width, height) in Excel?