Excel 2016, 2013, 2010, 2007
Barcode images in sheets
Excel 2016, 2013, 2010 & 2007
How to add a barcode image into an Excel 2016, 2013, 2010, 2007 sheet
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 of how to use the ActiveBarcode Generator click
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
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
Now open Excel and create a new sheet or open an already existing one.
Select the "Start" tab. Click on the button "Paste" from
the range of "Clipboard":
The barcode will be placed into your sheet:
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.).
Hint: The barcode has been added as image to your document. The images resultion has been set by you using
the ActiveBarcode Generator (Menu "Barcode": Layout & Size).
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!
This manual was created by Frank Horn