Print to labels ...

adambc

Board Regular
Joined
Jan 13, 2020
Messages
235
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
I have a Workbook that creates a series of same size arrays that I want to print to an A4 sheet of labels (L7202, 192mm * 38mm, 7 to a page) ...

Other than playing with the column widths and row heights, is there any way I can specify the print size of each array ie each array will print 192mm * 38mm (I know I will have to play around with spacing)?

FYI ... the arrays do not lend themselves to a "mail merge" ...

Thanks ...
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

mackc557

Board Regular
Joined
Nov 3, 2021
Messages
118
Office Version
  1. 2019
Platform
  1. Windows
Depending on what you are working with you could export the Excel data to Access and use the print with label formatting option. You can select the brand and specific size of label and it will know where to print from there. You can even customize how it looks on the label.
 

adambc

Board Regular
Joined
Jan 13, 2020
Messages
235
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Depending on what you are working with you could export the Excel data to Access and use the print with label formatting option. You can select the brand and specific size of label and it will know where to print from there. You can even customize how it looks on the label.
Unfortunately I don't have Access (macOS) ...
 

Forum statistics

Threads
1,175,999
Messages
5,900,794
Members
434,854
Latest member
ExcelMuffin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top