printing labels in excel

thijs · May 26th, 2002, 02:01 PM

I want to print pricelabels in Excel. Therefore I use a A4 sheet with 21
labels on (3 colums and 7 rows).
It should be possible to print different quantities (for example 1 label 10
times, another labels 6 times and another label 3 times) on 1 sheet at once.

In my worksheet I have a cell where I can enter a number of an article, and
the description and the price of this a article appears in the cells below.

How do I work this out (in a simple way)?

Nimrod · May 26th, 2002, 02:03 PM

Have you thought of using the excel spreadsheet as the database but using the labels option of "Mail Merge" in word as the front end ?

Jack in the UK · May 26th, 2002, 02:06 PM

Quite simply I would suggest using WORD as a male merge / print labels to do this, and make excel the data source. Its quick as simpler.

To answer YES Excel can do this, but this is WORD best feature.

Suggest a look at dreamboats site if you need more assistance, there she has it well detailed

thewordexpert.com

Will get you there.

HTH
|

thijs · May 26th, 2002, 02:08 PM

Does this work when I need different quantities on 1 page?

Yogi Anand · May 26th, 2002, 05:42 PM

Quote:

On 2002-05-26 13:08, thijs wrote:
Does this work when I need different quantities on 1 page?

Using Excel, if you have your database setup, you can use the INDEX Function to set up the labels in any way you like, multiple copies, mixed, in whatever fashion, and size to suit your requirements.
If these labels are price tags, you may want to consider, some thing like Avery Label sheets, with the label sizes pre set for you on an A4 or 8.5" x 11" sheet designed for use with inkjet and/or laser printers.
If this is the route you want to take, and you want further help in setting up your labels, please post back with your questions, and let us take it from there.

Regards!

Anne Troy · May 26th, 2002, 05:45 PM

thijs:

It would not be simple to set up to print, for instance, 3 of one label and 5 of another, and so on, using a Mail merge with Word. If that is your purpose, then stick with Yogi here.

However, you can print as many copies of the label sheets you want, for instance, 5 copies of the labels = 5 copies of each label, one on each set of sheets.

Sounds like you need Yogi's help if I understand you correctly.

Good luck!

May 26th, 2002, 02:03 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Have you thought of using the excel spreadsheet as the database but using the labels option of "Mail Merge" in word as the front end ? __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

May 26th, 2002, 02:06 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Quite simply I would suggest using WORD as a male merge / print labels to do this, and make excel the data source. Its quick as simpler. To answer YES Excel can do this, but this is WORD best feature. Suggest a look at dreamboats site if you need more assistance, there she has it well detailed thewordexpert.com Will get you there. HTH \| __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 26th, 2002, 05:45 PM	#6
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	thijs: It would not be simple to set up to print, for instance, 3 of one label and 5 of another, and so on, using a Mail merge with Word. If that is your purpose, then stick with Yogi here. However, you can print as many copies of the label sheets you want, for instance, 5 copies of the labels = 5 copies of each label, one on each set of sheets. Sounds like you need Yogi's help if I understand you correctly. Good luck! __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 26th, 2002, 02:01 PM	#1
thijs New Member Join Date: May 2002 Posts: 9	I want to print pricelabels in Excel. Therefore I use a A4 sheet with 21 labels on (3 colums and 7 rows). It should be possible to print different quantities (for example 1 label 10 times, another labels 6 times and another label 3 times) on 1 sheet at once. In my worksheet I have a cell where I can enter a number of an article, and the description and the price of this a article appears in the cells below. How do I work this out (in a simple way)?

May 26th, 2002, 02:08 PM	#4
thijs New Member Join Date: May 2002 Posts: 9	Does this work when I need different quantities on 1 page?