Row vs column size

  • Thread starter Thread starter Stanley Braverman
  • Start date Start date
S

Stanley Braverman

I am puzzled. Is it possible to have a row that contains say about 20 or so
characters.
And then the row below it starts about 5 characters after the beginning of
the row and then have both rows show up in a printing? :example
<-----coulomb A---------->
Time For All good men..etc
Yes It Can be-------------4546-03(column B)
<-------------column B----------- >
 
Yes it is possible. Just put five spaces in the cell on the second row
before beginning to type.
 
Footnote: If there is any data in the adjacent column on the right, the the
text in the left column will truncate at the edge of the cell unless you have
wrap text on.
 
I am puzzled.  Is it possible to have a row that contains say about 20 or so
characters.
And then the row below it starts about 5 characters after the beginning of
the row and then have both rows show up in a printing?  :example
<-----coulomb A---------->
Time For All good men..etc
         Yes It Can be-------------4546-03(column B)
          <-------------column B----------- >
Click to expand...

You are really talking about two rows one starting in Column "A" and
the other in Column "B". Column "A" should match 5 characters in
width (size depends on your Font) and Column "B" can be wide enough to
support all the remaining characters after the first five. You do not
need to but you can merge column "A" and "B" in the first row.
 
The rows are different widths. I need full row width on column A and
adjustable widths on column B but column B must be able to fit under column
A??

Allman Brothers Band, The (column A)

Candy Everybody Wants DK082-04 (Column B)
4Non Blonds (column A)

What's Up DK086-07 (column B)


I am puzzled. Is it possible to have a row that contains say about 20 or
so
characters.
And then the row below it starts about 5 characters after the beginning of
the row and then have both rows show up in a printing? :example
<-----coulomb A---------->
Time For All good men..etc
Yes It Can be-------------4546-03(column B)
<-------------column B----------- >
Click to expand...

You are really talking about two rows one starting in Column "A" and
the other in Column "B". Column "A" should match 5 characters in
width (size depends on your Font) and Column "B" can be wide enough to
support all the remaining characters after the first five. You do not
need to but you can merge column "A" and "B" in the first row.
 
You can waterfall the entries, so long as they are on different rows. Ther
restriction is that text in one column (any column) will truncate at the
right edge of the column if there is any type of datat in the column to the
right, including a space which you cannot see. Also as I previoulsy pointed
out, You can use just column A and expand it as wide as you need and use
spaces to make the waterfall effect. What have you tried?
 
Thanks for your reply. My problem is that I can not waterfall the effect as
I need column B to run almost into most of column A. What I really think I
need is a macro that would look at the contents of cells in column A and
then insert a complete row ABOVE any cell that contains text and move that
text to the new created row. Then I would be able to waterfall the rest B,
C, etc
 
Back
Top