Lynn, There are three ways of dealing with text that won't fit into a column. First, if there is nothing to the right of the text, it will be extended to the right which is when you hear "overlap."
Second, you can make the column wider by increasing the column width. I get to this dialog by pressing ALT-H, O, and then W. Usually the default is 8.43 which really means 8 characters. Remember that if you make too many columns wide, they won't all fit on a screen or on a printout. The third way of dealing with this situation is to specify that the text can be wrapped. This is part of cell formatting, so if you want to allow the text in a given column to be wrapped, you have to select the entire column first with CONTROL-SPACE. Then set all cells in that column to wrap with ALT H, W. This means that if text is too wide, it will be wrapped onto multiple lines within the column. Best regards, Steve Jacobson On Sun, 23 Mar 2014 13:59:19 -0500, lynn white wrote: >I really appreciate the help you guys have provided me with excel. >I'm seeing a message that says that when I enter text in a field that is >either clipped or overlapping. This tells me that I need to give more >room for that field. How is this done? >Also, there are times when entering text that I bring up the text >wizard. How do I enable myself to have more control of this and what >does the text wizard actually allow? >Sorry to be learning excel on the fly. But, I have a deadline to get a >report done. I have promised myself that really learning excel is a must. >Thanks. >If you reply to this message it will be delivered to the original sender only. >If your reply would benefit others on the list and your message is related to >GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. >GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage >your list subscription at http://www.gwmicro.com/listserv. If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage your list subscription at http://www.gwmicro.com/listserv.
