Excel 2013: how to display tab and other non-printing characters

Question

_{Tuesday, November 14, 2017 1:45 PM}

Up until recently, Excel would display tab characters as an empty box character.

They were displayed on the sheet and in the edit box.

Now they are simply not displayed.

I've turned "Display Control Characters" on but it makes no difference.

Any ideas?

Many thanks,
e.

All replies (2)

_{Wednesday, November 15, 2017 9:59 AM}

Hi,

Please refer to this support article and check if the reply will help you:

https://superuser.com/questions/529585/how-to-display-or-view-non-printing-characters-in-excel

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If you would like further assistance please let me know and I'm glad to help you.

Regards,

Emi Zhang

Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact [email protected].

_{Wednesday, November 15, 2017 12:38 PM}

Thanks for the reply.

Unfortunately none of the suggestions is useful in the first instance.

Excel used to work in this way.

It seems unusually arbitrary that this has changed like this.

Do you have any idea what the "display control characters" option is supposed to do?

I suspect, given that there was a rather unpleasant bug associated with this on release (which has been fixed, yay!) that it's supposed to do exactly what it says it does but does not.

Thanks again,
e.