How to make barcodes in Excel

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make barcodes in Excel
You can create barcodes in Excel. (Comstock/Comstock/Getty Images)

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.


  1. 1

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

  2. 2

    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.

  3. 3

    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 centred within the cell.

  4. 4

    Double-click on the formula in column A. Right-click and choose “Copy.” Paste the formula into the adjoining cell in column B.

  5. 5

    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.

  6. 6

    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 unrecognisable characters have appeared instead of a barcode, check the formula in column A for any spaces or unrecognized characters.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.