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
How can I display control characters in Excel 2007? 1
Viewing Control Characters 3
Set max characters in cell (Excel 2007) 4
Why can't I get more than 255 characters in one cell in Excel 07? 1
How many characters in text box in Excel 2007? 1
How do I get more than 255 characters into a cell? 3

Top