Excel help

BaZmO*

Hopefully this is the right forum.

Quick question that hopefully somebody can help me with.

I have a sheet in Excel that I need to print but I want to put all the information on one page. In simplest terms, the sheet has a lot of columns (say A - Z) but not that many rows (say 1 - 10).

I know you can just scale it down and put it on one page but all the information becomes too small.

What I'd like to do is have it so the A - M prints on the top of the page (in landscape mode) and the N - Z prints on the bottom of the page. (hopefully that makes sense?)

Is it possible to do this?

homer911

Can you not simply move your data in the spreadsheet?

If not, then create a separate part of the spreadsheet, or a further sheet just for printing purposes, then reference the original cells with formulas..

BaZmO*

homer911 wrote: »

Can you not simply move your data in the spreadsheet?

I could move the data, but's it's the "simply" element is where I'd fall down. It's just a pain to do.

homer911 wrote: »

If not, then create a separate part of the spreadsheet, or a further sheet just for printing purposes, then reference the original cells with formulas..

I'd be fairly proficient in Excel so I could work around it, but I'd just like to know if there was a way to do it in the printing options

Thoie

Does it have to be that way around - say for example your range is A1:Z4 (26 columns, 4 rows), you could use the paste transpose functionality to change it to A1:D26 (4 columns, 26 rows).

In order not to mess up the original data, copy the existing info, open a new tab (or sheet) and rightclick in A1, then paste/transpose in Excel 2007+ or paste special (for earlier versions) then select transpose.

BaZmO*

Thoie wrote: »

Does it have to be that way around - say for example your range is A1:Z4 (26 columns, 4 rows), you could use the paste transpose functionality to change it to A1:D26 (4 columns, 26 rows).

It'd have to stay that way. It's something that comes up a bit it'd be nice to have the option to print the info on one page in A4 rather than 2 pages or 1 page in A3.

homer911

Another option would be to embed the printable sections of the workbook separately in a Word document, one below the other..

homer911

Or you could specify a Print Titles area being the left part of the data and the print area as being the right part of the data?

Capt'n Midnight

or you could leave the data unchanged and in cell A15 add the formula =N1

then copy that cell to give you a live copy of N-Z at the bottom of the page.


Landscape is also good, play with margins too , rotate colunm title font alignment to vertical

BaZmO*

Thanks for the suggestions.

I came up with a kinda solution. In the printer settings I printed multiple pages to the one page. Not the best solution but it saves and paper.