print labels

Citizen Clp-7201e - citizen clp-7201e th...
January 13, 2010 at 23:29:51
Specs: Windows XP
Hi all,

I have a Citizen CLP-7201E Thermal Bar code printer. I need to print labels but the label has 2 columns. I need to print serially from left to right so as to utilize both columns while printing labels. Any help. I have the labels serially in excel. Am using micorosft excel XP. Please advise on what other programs i need to be able to print such ways.

Thank you,

See More: print labels

Report •

January 14, 2010 at 05:05:57
Have you tried using Word?


Report •

January 16, 2010 at 22:32:39
Hi Jennifer,

Sorry for the late reply. No i have not tried word. The labels are printed using Excel. Also sometimes i have to print more than 1000 labels at a time, so I have not tried Word. My boss wants me to use Excel to print. Any ideas plz. Is there a separate software for me to print on two column stickers? I have tried to search for it, but i havent been successful in finding any information regarding that.


Report •

January 17, 2010 at 07:35:16
Don't waste time looking for another program to perform your task. Word will do what you want. If the data is in Excel, just use Mail Merge.


Report •

Related Solutions

January 18, 2010 at 14:09:33

Here is a suggestion for moving you 'serial', presumably single column of labels to two columns, whilst maintaining the correct order.

The copies of the labels have an empty column first then the first column of labels then another empty column and finally the second column of labels.

The blank columns can be sized to adjust the printing positions.

Create two number sequences.
In column B enter 1 in B1 and 3 in B2
In column C enter 2 in C1 and 4 in C2
Select All 4 cells and drag down a few rows to get the alternating sequence.

In cell E1 enter this formula:


In cell G1 enter this formula:

Drag cells E1 and G1 down a few rows.

Here is a sample layout L1 to L10 are the original lables in column A starting at cell A1.

	A	B	C	D	E	F	G
1	L1	1	2		L1		L2
2	L2	3	4		L3		L4
3	L3	5	6		L5		L6
4	L4	7	8		L7		L8
5	L5	9	10		L9		L10
6	L6						
7	L7						
8	L8						
9	L9						
10	L10						

Now select cells D1 to G5
Select Print and Select the 'Selection' button
Select Preview to get a preliminary look at the page.
Adjust the widths of columns D and G

You could also make this alternate lines so that you can fine tune the space between labels.

I have no idea if this will work - just a crazy idea.


Report •

January 21, 2010 at 20:04:50
Hi all,
thanks for ur suggestions. I wasnt able to print serially using the above method. Also, using word envelopes and labels option also has not helped much. It isnt centering, nor am i able to adjust the spaces to match the column and row width. I am still trying to find a solution.

Anyother ideas?


Report •

January 22, 2010 at 06:32:20
What brand of labels are you using?
I know that Avery often supplies templates for their labels to make life a bit easier.
Try looking at the manufacturer web site.


Report •

January 31, 2010 at 00:10:58
Hi all,

sorry for late reply. My boss brought the labels from HongKong, so there is no official name that i can read on the label package.

Also, now i have tried by assuming both columns as single column label and using the spaces and margins to print on both labels. I have managed to successfully print around 60+60 rows continiously. But for other printing, it is taking time to arrange the margins and spaces. I will try to search for any other methods still.
Thanks, if any more ideas, it would be grateful.


Report •

Ask Question