How do I force truncation of text that is too wide for a cell when printing - I don't want to use word wrap.

Question

How do I force truncation of text that is too wide for a cell when printing - I don't want to use word wrap.

Anonymous

Initially Excel 2003 would truncate text that is too wide for a cell when printing, but with SP3 the extra characters are printed over top of characters in the next cell or cells (same for Excel 2010) . How can I force the printing to end at the cell boundary? It looks all right in Print preview - only the characters that fit are showing, but when printed the extra characters overlap with whatever is in the cell or cells to the right.. I don't want to use word wrap - there are several celIs with "excess" data, but I want to see just the amount of just the initial part of the text for such cells.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

9 additional answers

Answer 1

Did you follow the option to use word wrap and change the row height to 15 so that the text will be truncated. For Excel 2010 you may follow the steps given below and check if it helps:

Select the entire sheet (ctrl+a).
Right anywhere on the sheet and choose the option Format Cells.
Select Alignment tab.
Under Text Control group check the option Word Wrap.
Select the entire sheet (ctrl+a).
Right anywhere on the sheet and choose the option Row Height.
Under Row Height enter 15 and click Ok.

You may post your suggestions in the Feedback forums mentioned below:

http://mymfe.microsoft.com/Office/feedback.aspx?formID=375

Answer 2

Did you print the XPS file?

As RonRosenfeld recommended, you may use word wrap and use row height to adjust the height.

· Click on Format< Cells< Alignment< under Text Control check the box Wrap Text.

· Then click on Format< Row< and set the Row Height to 15.

As Excel Works fine when you change the Default printer, contact the printer manufacturer to update printer drivers and check if it helps

Answer 3

Why is using wrap-text not acceptable?

If you use wrap-text, but set the rowheight to be equal to just a single line of text, you should only see just the first line, which would seem to meet your requirement of removing the overlap. In addition, printing seems to show the same thing (just the first line; hence the extra data does not get printed).

Answer 4

As suggested, I changed the default printer to 'Microsoft XPS Document Writer', and then printed.

An xps file was created which was to be saved in the Documents folder. When I opened it, it had the fields truncated. However, when I printed it to the real printer, the wide fields were not truncated - they were spread across the cells to the right, and printed over the text that was supposed to be there. So the .xps format looks like what I want, but can't be printed correctly. Any other ideas?

Answer 5

Anonymous

Change the default printer to 'Microsoft XPS Document Writer' and then try to print and check if it works fine. Refer the link below to change the default printer in Vista/Win7:

http://windows.microsoft.com/en-US/windows-vista/Change-your-default-printer

0 comments

Share via

How do I force truncation of text that is too wide for a cell when printing - I don't want to use word wrap.

9 additional answers