Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Word wrap problem - Merged cells | Excel Discussion (Misc queries) | |||
Getting word wrap to work in a merged cell | Excel Discussion (Misc queries) | |||
Why won't my text fully display with word-wrap and merged cells? | Excel Discussion (Misc queries) | |||
word wrap in non-merged cells | Excel Discussion (Misc queries) | |||
Can word wrap and merged cells auto row height properly in Excel | Excel Discussion (Misc queries) |