how to use labels in openoffice 3.2

Asked by contentprovider on 2011-01-29

I have some insertable tabs for a three hole notebook. They have a program in Microsoft word that establishes a template for them so that the label positions in the middle of the page can be typed on a printer.. There are instructions for the word software but none for the openoffice.. any ideas thanks

Question information

English Edit question
Ubuntu Edit question
No assignee Edit question
Last query:
Last reply:
Tony Pursell (ajpursell) said : #1

Tony Pursell suggests this article as an answer to your question:
FAQ #1433: “How do I print Labels from data in a spreadsheet?”.

Tony Pursell (ajpursell) said : #2


I have given you a link to a FAQ I did a while ago because it contains some general ideas on producing labels. I realise it may not answer your question.

I will need a better description of what you are trying to print. Are these tabs arranged as parts of a larger sheet, n tabs across and m tabs down? Or are the single pieces in a continuous roll, or something. A more complete description with sizes and shapes would be useful.

Also, for completeness, please tell us which versions of and Ubuntu you are using.


These are Avery "Big Tab" inserts. The document to be printed appears in the center of an 8.5 by 11 page..bordered by printing tips on each of the two outer columns. The two column tabs are in horizontal side by side and each pair is par of the total of the tabs that run the 11' length.
They two columns of blank tabs serve as inserts for plastic subject dividers[which extend outside of the normal 8.5 by 11 page. for three ring notebooks.
Thanks for the help thus far.. I will study the FAQ #1433

Tony Pursell (ajpursell) said : #4


Are they like this:

In which case you may find them listed under Format on the Labels dialogue as a Type with Brand changed to Avery Letter Size. If not, you will have to put the data from the printing tips (Para 4 in the example in the link above) into the label dimensions on the Format tab and Save them as a user defined format.

To follow the FAQ I quoted, you will first need to list the tab contents in a Calc spreadsheet. You will probably only need one column of data with a heading in row 1 (say, 'Tab Text') with each cell below it containing the text for one of the tabs. Does your format have 2 columns of 26 rows of tabs? Then you will have to repeat the tabs as many time as you need to fill the page. For the example from the link above, which only has 5 tabs, you would need them repeated 10 times and 2 tabs will be unused.

Just one tip - always print on plain paper first to check that the printing is correctly lined up.

Let me know how you get on and do get back to me if you need more help.


PS If this answers your question, please mark it as Solved

Can you help with this problem?

Provide an answer of your own, or ask contentprovider for more information if necessary.

To post a message you must log in.