Print problem with columns

  • Thread starter Thread starter Still learning@work
  • Start date Start date
S

Still learning@work

I have inherited a spreadsheet and need to print it on one page. All the
information is 2 columns. Is there a way to get the columns to wrap on a
page so instead of having 3 pages with 2 columns each, I can have one page
with six columns?
 
There is no direct method...

If you can print, say 50 rows per page, then you can do this
enter in C1
=A51 and copy one col right and 50 rows down...
If you are still left with values then enter in E1
=A101 and repeat the above

Print only rows 1-50...
 
Back
Top