Paste and Text Wrap (2003 SP3)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

Thanks. I have suggested both options.

Jester

Reply | Quote

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.

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?

Reply | Quote

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 SettingsApplication DataMicrosoftExcelXLSTART. 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.

Reply | Quote

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 SettingsApplication DataMicrosoftExcelXLSTART. 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.

Thanks Hans – thats great info

Reply | Quote