- In short
- Creates a Code 128 barcode picture for each value in your selection and places the pictures on the sheet. The barcodes are generated on your computer with no font or internet needed. The value is used exactly as written, so codes with leading zeros are kept. Your source cells are not changed and you can undo to remove the pictures. Barcode picture shapes. Your source data stays unchanged and can be reversed in one step with Undo Last.
What it is for
Create Barcode is used to generate local Code 128 barcode pictures from cell values.
When to use it
It earns its place whenever you have to make printable barcodes from product/stock codes.
Example scenarios
- Make printable barcodes from product/stock codes.
What it needs
an options dialog (width/height/show-source/skip-blanks) + pick source + output cell; ≥100/≥300 confirm; protected output refused. Supported data types: text, number, date (by selection).
How to use it
- Select the range to work on.
- Run Create Barcode from the Practical group on the XLMind Data tab.
- Adjust the options in the window to fit your case.
- Confirm; barcode picture shapes.
What it produces
Barcode picture shapes.
Effect on your data and undo
Create Barcode does not change your source data; the result is added as a separate item. If it is not what you wanted, Undo Last restores the previous state.
How it differs from similar tools
It works without formulas and never touches the source range; the result is produced separately, so the original table keeps its formulas intact.
Good to know
Confirmation for large operations. Protected cells refused; size limits (≥100/≥300 confirm).
Limitations
Protected cells refused; size limits (≥100/≥300 confirm).
Frequently asked questions
- Where will I see the result?
- Barcode picture shapes.
- What happens to invalid or unexpected values?
- Non-ASCII values skipped.
- Does the result stay linked to the source?
- The output does not track the source afterwards; a quick rerun brings it up to date.
- Any known limits?
- Protected cells refused; size limits (≥100/≥300 confirm).
Works well with
- To tidy the data first, use Image Validation
- As a next step, use Create QR Code
- Often used alongside this tool: Export to PDF
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.