View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Print problem with 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...
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Still learning@work" wrote:

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?