ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Display or hide control characters in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/251157-display-hide-control-characters-excel-2007-a.html)

schackbo

Display or hide control characters in Excel 2007
 
In Excel 2007, how can I display or hide control characters? I can't find
that option. I want to be able to see control characters in my spreadsheets
(i.e. carriage returns, etc.).
Thanks

Gord Dibben

Display or hide control characters in Excel 2007
 
Excel has very limited capabilities as a word processor.

If you have linefeeds in a cell, disabling "wrap text" will show the
linefeeds as small squares.

Other than that...............I know nothing<g


Gord Dibben MS Excel MVP

On Tue, 15 Dec 2009 20:25:01 -0800, schackbo
wrote:

In Excel 2007, how can I display or hide control characters? I can't find
that option. I want to be able to see control characters in my spreadsheets
(i.e. carriage returns, etc.).
Thanks




All times are GMT +1. The time now is 04:52 PM.

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