Creating a Barcode in Excel Step One: Create two columns in a blank spreadsheet. ... Step Two: Format the cells in the Text column. ... Step Three: Enter the following formula: ="*"&A2&"*" in the first blank row of the Barcode column. ... Step Four: Fill the Barcode column down. Step Five: Change the font in the Barcode column. More items... Aug 8, 2019