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

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

1. Select the Code 128 barcode you need adjust its image width and height
2. 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
3. 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.

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

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).

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

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.

1. Select the target QR Code barcode image. Use the bouning box handles to resize the barcode image.
   
   
   
   Note:
   QR Code should be a square shape. You can press shift during resizing, Excel will automatically maintain the aspect ratio during QR Code image resizing.



2. 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.
   
   



3. 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.
   
   



4. 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.
   
   



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

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

Here are the steps to follow:

1. Select the target barcode image
   
   



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

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

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

1. Uncheck option "Auto resize".
2. Input 10 pixels for both "Bar width (X)" and "Bar height (Y)".
3. 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.

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.

1. Select the Code 128 barcode on cell B2
2. Find the option "Apply min quiet zones" in tab "1D Barcode", uncheck it.
3. 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).

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.

1. Select the QR Code in Excel
2. Uncheck the Is padding area transparent option under tab "Barcode Size"
3. 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.

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.

Here are the steps:

1. 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"
   
   



2. Now we need change the displayed barcode text font size.
   
   Go to tab "1D Barcode", change font size to 18
   
   



3. Last step, we need increase the space between bar code and displayed barcode text.
   
   Go to tab "Barcode Size", change Text margin to 24
   
   

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.