wrap a row

  • Thread starter Thread starter y a duck
  • Start date Start date
Y

y a duck

Sorry if this is redundant, but I'm looking for a way print a row in
excel and have it wrap to 2 lines (not wrap text within a cell). An
example would be a spread sheet with 6 columns. The first 5 are simple
columns of proj, task, lead, strt, end. Column 6 is a detl text box. I
would like column 6 to be printed under the first 5 columns:

Entered as:

proj task lead strt end detl
c111 1001 john 01/01/04 02/28/04 aaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbb
cccccccccccccccccc

Printed as:
proj task lead start end
detl
c111 1001 john 01/01/04 02/28/04

aaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbb
bcccccccccccccccccc

Hopefully, the examples line up, but if not, in the first example the
line of abcs should be under the detl column. In the second they are
spread across the width of columns 1 - 5.
 
For the most part Excel tries to print data exactly as it appears on screen.
So I think you'll have to find a why to temporarily move the data before you
print.
 
This might work - you could have the cell in the 'proj' column be equal to
the cell with the aaaaaaa etc in. Then merge and wrap the cell (select all
5 cells, cell, format, alignment tab, select merge and wrap). If detl
column is not wrapped and is only wide enough to print the 02/28/04 and not
the aaaa etc, this may give you what you want.
Barbara.
 
Back
Top