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 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
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 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