LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default Word wrap issues within merged cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word wrap problem - Merged cells Helen Excel Discussion (Misc queries) 1 March 12th 09 05:39 PM
Getting word wrap to work in a merged cell Dave Couch Excel Discussion (Misc queries) 1 October 31st 07 11:17 PM
Why won't my text fully display with word-wrap and merged cells? Will DeLoach Excel Discussion (Misc queries) 9 November 14th 06 04:52 PM
word wrap in non-merged cells Arun Excel Discussion (Misc queries) 2 October 20th 06 05:55 AM
Can word wrap and merged cells auto row height properly in Excel wchernock Excel Discussion (Misc queries) 1 May 30th 06 03:04 PM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"