Text not consistantly appearing in adjacent cells

S

Stuck Again

I have a multi page spread sheet where there are a few
inconsistancies:

(1)

My pages have a header that spans several columns once it
pulls in an organization's name. On most of the pages the
header appears fine even though it displays over several
columns. On a few of the pages the header only appears
partially -- displaying only the characters that will fit
in the column width of the cell containing the header.

As all of the adjacent column cells the header appears
next to are blank, I just merged all the cells to
eliminate this problem, however on two of my sheets I made
very elaborate comments that were linked to a cell in the
column next the header. (comments in column to the right
of it). Once the organization's name is pulled into the
header then the full header does not display into the
adjacent cells. Although I have moved the
comments "display" over, I am unable to move the link.
I can't merge the cells because the header and the
comments are two different data sets. I can't really cut
and paste the header as I loose all formatting. (Very
elaborate comments -- about 30 mins worth of formatting).

(2)

I have a comments section that is supposed to allow the
user to type in about 10 lines of text -- however any text
exceeding the width of the line does not appear over top
of the next row. (In text alignment I have "word-wrap"
enabled). I do not want to merge all 10 lines as
sometimes it will be needed to itemize things (ie
Ticket# 123323 Lost
Ticket# 347382 Stolen
Ticket# 239483 Destrpyed )

Any ideas on how I can resolve these problems?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top