![]() |
Row vs column size
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----------- |
Row vs column size
Yes it is possible. Just put five spaces in the cell on the second row
before beginning to type. "Stanley Braverman" wrote: 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----------- |
Row vs column size
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. "Stanley Braverman" wrote: 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----------- |
Row vs column size
On Feb 7, 7:47*pm, "Stanley Braverman" wrote:
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----------- 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. |
Row vs column size
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) "Canlink" wrote in message ... On Feb 7, 7:47 pm, "Stanley Braverman" wrote: 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----------- 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. |
Row vs column size
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? "Stanley Braverman" wrote in message ... 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) "Canlink" wrote in message ... On Feb 7, 7:47 pm, "Stanley Braverman" wrote: 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----------- 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. |
Row vs column size
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 "JLGWhiz" wrote in message ... 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? "Stanley Braverman" wrote in message ... 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) "Canlink" wrote in message ... On Feb 7, 7:47 pm, "Stanley Braverman" wrote: 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----------- 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. |
All times are GMT +1. The time now is 09:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com