I have a narrow table that I want to print on an A3 sheet of paper (landscape). Rather than have half the sheet empty, how do i get the table to flow onto the other side of the A3 sheet then onto the NEXT page? surely there is a way?
I think I know what you are trying to do and would recommend printing the table via Word as this can easily set the data out in columns.
In Excel select the range of cells you want to print then click [copy] (ctrl + C).
Open Word – with a suitably sized document (in your case A3) – and click where you want the tabular data to start then click [paste] (ctrl + V). The data will be transferred to form a multi-page document - all down the left side.
On the Word tool bar click on the “columns” icon and swipe across the drop down figure to select the number of columns you want. The data should then automatically be transformed into those columns.
You may need to tweak things a bit to get the presentation you want but it is workable.
All the above is based on Office XP (2002).
This thread is now locked and can not be replied to.