Excel needs a barcode font or add-in. The quicker way: copy your SKU column from Excel, paste it here and print barcode labels.
Excel has no built-in barcode feature. The usual way is to install a barcode font: with a Code 39 font you type the code between asterisks, like *SKU123*, and change the font. Code 128 needs a check character worked out by a formula or an add-in, so a font alone is not enough. You then have to size the cells to your sticker sheet by hand.
Keep your SKU list in Excel and let this page make the barcodes. Select the SKU column (and the product name and count columns if you have them), copy, and paste into the box above. Each row becomes a Code 128 barcode label, laid out for A4 sheets of 12, 24 or 40 or for 1×4 inch thermal rolls, in one PDF.
No font, add-in or macro is needed, and the labels already line up with standard sticker sheets. Print at Actual size (100%).
No. It needs a barcode font or an add-in; Code 128 also needs a formula for its check character.
No. Copy the columns and paste them here; the file stays with you.
SKU first, then the product name and the number of labels if you want them.
These are Code 128 barcodes of your own codes, good for inventory, bins and your own billing. Shops and big retailers that scan EAN-13 barcodes need numbers registered with GS1 India.