Setting the parameters when using the Excel bar code creator

Asked By Sjohn 30 points N/A Posted on - 05/03/2013

When using the Excel bar code creator, I have been experiencing problems when it comes to setting the parameter of the Height and Width, how do you set the width or the height for the bar code symbols?

Apart from that how do you set the rotation parameters as well? It is in zero, what are the ranges allowable? 

 

• Status: Open
• Question Views: 737
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Hensley Petri

Go To Solution

Best Answer

Best Answer

Answered By Hensley Petri 0 points N/A #145179

Setting the parameters when using the Excel bar code creator

Hi Sjohn!

What barcode creator add-in are you using for Excel? In Microsoft Excel if you are using the Tbar add-in, you will have 3 different sizing modes. These modes would allow you to manipulate the size of your barcode.

• Fit to Selected Cell – this sizing mode draws the barcode in the size of the selected cell.
• Fit into bounding box – the barcode is always drawn into the size of the bounding box. The module width adopts to the amount of data.
• Fixed module width – The width of the barcode is adjusted to the amount of data to be encoded.

Just select one of these options for you to customize the size of your barcode. There are for options for barcode rotation: 0, 90, 180 and 270 degrees. You can set it to 0 for no rotation.

About Hensley Petri

Questions
1

Answers
9

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 05/15/2013
• Question Category: MS Excel

Answered By Davidson Mudge 0 points N/A #145180

Setting the parameters when using the Excel bar code creator

Hi Sjohn,

If you are using Identicode in generating bar codes there is a way to set the width on it just first set the barcode type, then set the data, and then set the width.

You can do the same for the height. If you are having difficulty finding your way on your current barcode generator you can download Identicode here.

You might have more questions regarding barcode creation you can also check this add in it also has a tutorial.

Then you can see which one is easier for you to use.

About Davidson Mudge

Questions
3

Answers
500

Best Answers
197

• Vote Up 0 Vote Down

• Posted on - 05/15/2013
• Question Category: MS Excel