Column B pick up in printing

[grantell]

I have an Excel spreadsheet that is set up as A4, Landscape. The data goes over 2 pages in width. When I view the data in Print Preview and when I actually print the spreadsheet, column B is picked up and added as a first column on each printed page.
Can someone tell me how this happens, and if it is possible to add further columns in this ‘pickup’? i.e. I would like to add column D to this, so that both columns B & D are picked up and printed at the left of each printed page.
Any help would be greatly appreciated.

[CRIMEDOG]

in print preview click the page setup button - then the tab sheet has a repeat rows/ column option

[grantell]

Thank you for your help.
Jusyt had a look at your suggestion and now all I have to do is get the administrator to free up this option so I can use it