Barcode images in sheets


How to add a barcode image into an Excel sheet
Excel 365, 2021, 2019, 2016, 2013, 2010, 2007


You can use the ActiveBarcode Generator to add barcode images to your Excel documents:

Launch the ActiveBarcode Generator and create the barcode according to your needs. If you need information on how to use the ActiveBarcode Generator click here.

After creating the barcode you copy it into the Windows clipboard. To do this select Copy Bitmap or Copy Meta from the Edit menu. A description of the whole menu is located here.

Edit menu

If you want to place a bitmap image to your document use the function Copy Bitmap. You do this, if you need a barcode in an exact size.

If you want to place a vector graphics to your document use the function Copy Meta. You do this, if you want to freely resize the barcode in your document.

The barcode will now be copied to the Windows clipboard and is available for nearly any application running on your system.

Now open Excel and create a new sheet or open an already existing one. Select the "Home" tab. Click on the button "Paste" from the range of "Clipboard":

Barcode, Excel


The barcode will be placed into your sheet:

Barcode, Excel


The barcode image is now placed to into your Excel sheet. You can handle this barcode inside your sheet as any other image (e.g. resize, move, etc.).

The barcode has been added as image to your document. The images resultion has been set by you using the ActiveBarcode Generator. If you create the barcode in a low resolution (e.g. 200x50 pixels) and then print it to a printer with a high resolution the barcodes textline may look like it has a too low resolution and huge blocks are visible. This also happens when you resize the barcode inside your document to get it bigger. To avoid this you must create the barcode in a bigger resolution before you copy the barcode to the Windows clipboard. Then you paste the barcode image to your document and resize it to the required smaller size. Now the resolution of the image is higher and if you print your document the barcode will look much better!