How to Print Bar Codes in Microsoft Excel

By Suvro Banerji

Excel is a spreadsheet program from Microsoft. In addition to creating and editing databases and tables, Excel is capable of creating bar codes. Using a macro-based function, Excel is able to create bar codes for any given formula. You can print these bar codes and can you them for all the products you are selling.

Things You'll Need

  • Microsoft Excel

Step 1

Launch Microsoft Excel from the Microsoft Office folder in your Start menu.

Step 2

Click the "Tools" drop-down menu. Select the "Macro" tab, and choose "Security." Set it to "Medium." If you use Office 2007, click on the Microsoft Office button at the top left corner and select "Excel Options." Click on "Trust Center Settings" under the Trust Center category. Click on "Macro Settings." Put a check mark next to "Enable all macros."

Step 3

Click the "File" drop-down menu and select "New." Select "Enable Macros" when you get a prompt. For Excel 2007, click on the Office button and select "New."

Step 4

Enter the formula for your specific bar code in Column A, which is the first column. Make sure to use only numbers and/or letters while developing your bar code formula. Also, do not add any spaces between the characters.

Step 5

Increase the width of Column B, the column next to the first column from last step. Click on the line that divides Column B and Column C and drag it to your right until you have enough space for the bar code.

Step 6

Double-click on the formula you developed and type it in Column A from Step 4. Right-click on it and select "Copy." Right-click on the next cell in Column B and select "Paste."

Step 7

Double-click to select all the formula in Column B. Select the "Font" drop-down menu. Choose the font that says "Bar code." This will transform the formula into a bar code.

Step 8

Select the cell with the bar code. Click the "File" drop-down menu and select "Print..." For Excel 2007, click the Office button and select "Print." Click "Print..." again.

Step 9

Choose "Selection" under the Print What sub-category. Click "Print" to end the task.