Word Wrap?

  • Thread starter Thread starter Chadzilla14
  • Start date Start date
C

Chadzilla14

Hello Everyone,
I have a spreed sheet that is 2 rows and 60 columns. If I print this
sheet it prints on 20 pages with 2 rows on each sheet. Does anyone know
off a way to print all of the data on a couple of sheets with out using
Macros to copy and paste. I mean is there a feature in Excel that will
"Word Wrap" Entire rows? Any help would be appreciated.
Chad
 
You could create a new worksheet, copy your range, go to A1 of the new worksheet
and edit|paste special|check transpose.

This'll create a 60 row x 2 column range.

Adjust the rowheight and try printing it.

If it's still too many pages, you could copy that transposed range once more and
paste into MSWord. Then format|columns to make it print more per page.

(I'm not quite sure what wordwrap entire rows means.)
 
If you want the sheet to print out A1, B1, C1 etc instead of the usual
A1, A2, A3..... you should go File, Page Setup and click the Sheet
tab.
At the bottom of this are the options "Down, then over" (Default) and
"Over, then down". By checking the Over, then down option the sequence
will follow the A1, B1, C1...... sequence.

Hope this is what you were after

Mike
 
Back
Top