S
Steph
I am trying to find a problem in a corporate Excel sheet for my boss. I
tried re-inventing the form from scratch, but have the same issue.
This form is a required daily log for field operations. It has the required
normal entries such as date, time, shift, job name ect. at the top. Below
this are several merged cells. There is the first large box to enter all the
"work performed" for the day, and then to the right is a long column for
temperature, equipment...I hope I giving you a visual.
The problem is with the large box that has about 7 columns by 30 rows merged
together. Word wrap is on, the text starts at the top, font 10. For a test
I just started typing from a book, hitting alt/enter for a new paragraph. I
can see ALL of my text as I am typing, and all the sentences are wrapping.
As soon as I click outside of the merge box to work on another entry, about
half way down all my information stops wrapping. So I see the first few
paragraphs that are wrapped, then each paragraph after that looks like a
one-line paragraph. When I look at print preview, I see the same thing.
When I click back inside the box, all words are visible and wrapped. So my
boss has to go in and insert a alt/enter at the end of each group of words so
it will force a wrap. It's very time consuming for something that has to be
done on a daily basis.
He gave me a challenge, I have tried everything. Can someone help?
Thanks!
Steph
tried re-inventing the form from scratch, but have the same issue.
This form is a required daily log for field operations. It has the required
normal entries such as date, time, shift, job name ect. at the top. Below
this are several merged cells. There is the first large box to enter all the
"work performed" for the day, and then to the right is a long column for
temperature, equipment...I hope I giving you a visual.
The problem is with the large box that has about 7 columns by 30 rows merged
together. Word wrap is on, the text starts at the top, font 10. For a test
I just started typing from a book, hitting alt/enter for a new paragraph. I
can see ALL of my text as I am typing, and all the sentences are wrapping.
As soon as I click outside of the merge box to work on another entry, about
half way down all my information stops wrapping. So I see the first few
paragraphs that are wrapped, then each paragraph after that looks like a
one-line paragraph. When I look at print preview, I see the same thing.
When I click back inside the box, all words are visible and wrapped. So my
boss has to go in and insert a alt/enter at the end of each group of words so
it will force a wrap. It's very time consuming for something that has to be
done on a daily basis.
He gave me a challenge, I have tried everything. Can someone help?
Thanks!
Steph