Ask Your Question

How can I print a spreadsheet to labels

asked 2018-05-30 12:48:11 +0200

_dave gravatar image

This is not a mail listing, I would like to print labels based on information within a spreadsheet. I have included a sample file that shows some data and an idea on what I need on the labels.

The labels are Avery sheets, the size of the labels are not defined yet.

Any suggestions or solutions is really appreciated.

thanks,C:\fakepath\Boxed Parts.xlsx

edit retag flag offensive close merge delete


You need to register your spreadsheet as database, so that you can use it in Writer with the wizards.
Looking into you example, I notice, that you are not looking for "labels". Labels have same size and structure. Your output looks more like a report. It might be, that you need a query to sort the records by Box number. So you should copy your data into a Base table, so that you can use all Features of Base.

Regina gravatar imageRegina ( 2018-05-30 13:33:28 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-01 10:56:18 +0200

hjek gravatar image

If you want to print only the part of your spreadsheet that has the labels, you can select those labels and click Format -> Print Ranges -> Define.

If you want to change the layout of the defined print range as printed on paper, click Format -> Page.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-30 12:48:11 +0200

Seen: 91 times

Last updated: Jun 01 '18