skip to Main Content

How to Make Barcodes in Excel

Author:

You are here:

Barcodes can easily and quickly be created using Microsoft Excel. The spreadsheet application can take a formula and automatically generate a barcode. Creating the barcodes in Excel allows you to have a spreadsheet of the codes that can be modified, sorted and edited.

Bar-Code Scanner

Bar-Code Scanner

  • Download a barcode font package into Excel. There are several barcode font packages available on the Internet; some are free while others can be purchased. To find Excel barcode font packages recommended by Microsoft, visit the Microsoft Office Marketplace and search for “Excel Barcodes.”
  • Open a new spreadsheet in Excel. Type in the formula you will be using for the barcode in column A. The formula should only contain numbers or letters with no spaces in between.
  • Format column B so that it will be wide enough to hold the entire barcode by clicking on the line dividing the column B and C headings and dragging the line to the right. Make sure there is plenty of room for the barcode; it will need to have blank space on either side. Highlight column B by clicking on the heading and click the “Centered” icon so the barcode will be centered within the cell.
  • Double-click on the formula in column A. Right-click and choose “Copy.” Paste the formula into the adjoining cell in column B.
  • Highlight the formula in column B. Click the “Font” pull-down menu and scroll down to the barcode font and click. The formula will change into a barcode. Highlight the barcode and adjust its size using the pull-down font size menu. The standard barcode size is 12 point.
  • Check the barcode in column B with the formula in column A to make sure that it has formatted correctly. Formatting mistakes are quite common when creating barcodes, so check each code. If unrecognizable characters have appeared instead of a barcode, check the formula in column A for any spaces or unrecognized characters.

 

If you are facing any kind of issues call us on our toll-free number 1-800-293-9401.

Tags:
Was this article helpful?
Dislike 0
Views: 32

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top