Formatting problem

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I am trying to 'improve' the formatting of a workbook containing many
sheets. My basic problem is this. The person who set up the sheets didn't
use text wrap. Once they got to the end of a line (when typing text) they
went onto a new row. They then tried to put borders round the cells but
missed out many cells. The result is a total mess - odd borders everywhere
and text spread over many cells.

I am trying to improve the design. I am trying to put a whole paragraph in
one cell but this is extremely time consuming. It involves cutting the text
from each row and pasting it to the end of the text in a single cell. Is
there a faster way to join up text like this? Or do I simply have to plough
my way through 40 sheets, cutting and pasting to join up text??!

Also, is there any way of using fields in Excel? Each worksheet has
something like 'Year 2003-2004' as a heading on each page. However, as I
plan to use this workbook as a template, I thought it might be useful if I
could just insert a field (as in Word). In this way I could use the field to
insert the text instead of typing it over and over again.

Hope this is clear.
 
Colin,

Maybe not the best solution, but if the data is all in one column you can
copy that column into Word and then merge the cells that should be together.
Then just copy back into Excel and format with text wrap.

I did a quick test and the merge in Word didn't overwrite any of the cells
and it was unnecessary to eliminate the hard returns that Word inserted when
the cells were merged as Excel did not seem to recognize them.

HTH

PC
 
Thanks. It didn't seem to work in Excel 2000. When I pasted the merged cells
back into Excel they just went straight back into separate rows.
 
Back
Top