I am creating a catalogue in excel and often need to add data and reprint. The problem is that the layout is that the data starts on the left of the sheet and then at the bottom of the page goes to the right half of the page.

When i set this up i just manually typed the data in and fitted it on to each page. Now when i insert cells with new data in the middle of the sheet , rather than continuing onto the right of the page it will push the data down onto the next page and therefore i lose the sections I have created.

How can i have the data linked as left and right of a page? I hope this is clear as it is hard to explain...