View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
richzip richzip is offline
external usenet poster
 
Posts: 74
Default splitting long columns

I have a spreadhseet that has about 800+ rows (2 columns), which takes
several pages. I am convering this sheet to PDF. Is there a way, within
Excel, that I can automaticaly split after a set number of rows, copy the
data and paste it to the top of the page in different columns? This way
..intead of 2 column x 800 rows (and 15 pages), I would have 8 columns x 200
rows (and 4 pages).