ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Label printing (https://www.excelbanter.com/excel-discussion-misc-queries/188104-label-printing.html)

belwest

Label printing
 
How do I change the text size and alignment of one line only when priting
labels

Gord Dibben

Label printing
 
Select that row and make the changes under FormatCellsFont and Alignment.

Excel alone is poorly suited for creating labels.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source see these
sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Mon, 19 May 2008 15:51:01 -0700, belwest
wrote:

How do I change the text size and alignment of one line only when priting
labels




All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com