Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste and Text Wrap (2003 SP3)

    Two users out of many find that when they paste text into a cell within one worksheet they don't get the text to automatically wrap like it does for all others.

    I have been told it is just this one file and just two users.

    So far I have suggested some vanilla things for the users to try as I have not had the chance to follow some of the steps listed in the "systematic troubleshooting" material. Also, Excel starts and runs fine for these users other than this one file and one scenario.

    I am curious if anyone has some suggestions or questions?

    Jester
    I know enough to know I don't know enough

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste and Text Wrap (2003 SP3)

    How do they paste? Text wrapping is off by default in Excel.

    If you click on a cell to select it, then paste, text wrapping will not be turned on automatically.

    If you double click a cell (or click in the formula bar, or press F2) to edit the cell's contents, text wrapping will be turned on if the text consists of multiple paragraphs.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste and Text Wrap (2003 SP3)

    Here's what I learned... the users are copying from Outlook into Excel so I think they are just encountering the nature of the beast and the comment about only 2 users might be a red herring. I suspect only these two users are copying and pasting and only pasting into this file. I thought other users and other files behaved differently.

    I have shared with them the above information about text wrap being off by default.

    If there is no way to turn such a feature on globally or for a range in advance then I shall put a fork in their incident.

    Thanks,

    Jester
    I know enough to know I don't know enough

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paste and Text Wrap (2003 SP3)

    You can select a range of cells or even a whole sheet, and tick the Wrap Text check box in the Alignment tab of Format | Cells...
    Another option is to turn on Wrap Text in the Normal style - the style that is applied to all cells by default until the user selects another style.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste and Text Wrap (2003 SP3)

    Thanks. I have suggested both options.

    Jester
    I know enough to know I don't know enough

  6. #6
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='742607' date='14-Nov-2008 06:19']You can select a range of cells or even a whole sheet, and tick the Wrap Text check box in the Alignment tab of Format | Cells...
    Another option is to turn on Wrap Text in the Normal style - the style that is applied to all cells by default until the user selects another style.[/quote]

    Hi Hans,

    excuse my ignorance, but how can you set your normal style for all new workbooks, ie as you can for normal.dot in word?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Set up a workbook exactly the way you want all new workbooks to look.
    Save it as an Excel template named Book.xlt (this name is obligatory) in your Excel start folder, usually C:\Documents and Settings\Application Data\Microsoft\Excel\XLSTART. This template will be used for new workbooks if you do not explicitely create it from another template.
    Then delete all sheets except one, and save as an Excel template named Sheet.xlt in the same folder. Again, the name is obligatory.
    This template will be used when you select Insert | Worksheet.

  8. #8
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='789315' date='17-Aug-2009 15:10']Set up a workbook exactly the way you want all new workbooks to look.
    Save it as an Excel template named Book.xlt (this name is obligatory) in your Excel start folder, usually C:\Documents and Settings\Application Data\Microsoft\Excel\XLSTART. This template will be used for new workbooks if you do not explicitely create it from another template.
    Then delete all sheets except one, and save as an Excel template named Sheet.xlt in the same folder. Again, the name is obligatory.
    This template will be used when you select Insert | Worksheet.[/quote]

    Thanks Hans - thats great info

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •