Printing one column into two (snaking)

ajc623

Board Regular
Joined
Nov 8, 2013
Messages
57
I have a list of products that I have employees use as a reference sheet to confirm item # with the right product. The sheet is set up as

column A - item #
column B - Item name
column C - Small picture of item
column D - how to package it

As I need to add/remove products from time to time I have it as a single "column" A-D list but since the info is fairly simple I would like to be able to print it with those 4 columns listed twice per page. I can fit twelve rows per page with a header on top. So my goal would be to have this

Row 1 - header in A-D and again in E-H
Range A2:D13 would be the first 12 products in my list
Range E2:H13 would be products 13-24 on my list

This would repeat with all remaining products in the list.

Thanks
Andrew
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,214,830
Messages
6,121,839
Members
449,051
Latest member
excelquestion515

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
Back
Top