ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding carriage return (https://www.excelbanter.com/excel-discussion-misc-queries/72807-hiding-carriage-return.html)

Abe

Hiding carriage return
 
I have an Excel spreadsheet that contains carriage returns in some of the
cells. This is necessary to get the lines to wrip where I want them to. On
my computer these lines display properly. In my co-worker's computer the
carriage returns display and print as little squares. How can I hide this
symbol?

Ron Coderre

Hiding carriage return
 
If you set the cell to wrap text on the other PC, the CR will engage instead
of showing a box.

FormatCellsAlignment tab: Check: Wrap text

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Abe" wrote:

I have an Excel spreadsheet that contains carriage returns in some of the
cells. This is necessary to get the lines to wrip where I want them to. On
my computer these lines display properly. In my co-worker's computer the
carriage returns display and print as little squares. How can I hide this
symbol?



All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com