Show or Hide control characters in a cell (using Excel 2007)...

T

TK

Hi,
I have a worksheet that contains carriage returns embedded in a cell. When I
open the sheet, I do not see these carriage returns, but my co-worker opens
the same sheet, he sees these carriage returns as control characters. There
is an option in Excel 2003 that you can set to show/hide these control
characters using the following method
(http://office.microsoft.com/en-us/excel/HP052626691033.aspx):
Tools -> Options -> Internations tab -> Show/Hide control characters.

I checked the whole Excel 2007 to accomplish the same task and couldn't find
anything of this sort.

Can you please let me know how I can accomplish this issue. Hope this is not
a bug in Excel 2007.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display or hide control characters in Excel 2007 1
Is there an option to view Special (control) Characters in Excel 2 3
Excel - carriage returns and formating of text within a cell 2
How do I get SQL data to show CRLF instead of question marks? 0
How can I display control characters in Excel 2007? 1
Unicode text and carriage returns 4
Viewing Control Characters 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top