Alt Enter Creates Tab Character

W

W

Usually if I enter Edit on a cell (F2) and hit Alt+Enter, it goes to the
next line within the cell and I can enter a new line of text. I am having
a problem on one worksheet of spreadsheet where Alt+Enter does NOT go to a
new line, and instead generates a visible tab character. The font is
the same (Arial Regular 8pt) between the two worksheets. What setting
might be causing this weird behavior?
 
G

Gord Dibben

Set the formatting to wrap text and you won't see the visible
character which is probably a linefeed 0010 character, not a Tab char.


Gord
 
W

W

Gord Dibben said:
Set the formatting to wrap text and you won't see the visible
character which is probably a linefeed 0010 character, not a Tab char.

I did this originally, and it does not change the result. I still see the
character at end of line, and I do NOT get a new line while remaining in
Edit mode (F2 on the cell). And you are right it was new line character
because if I save the change I do see second line on the second line. So
data entry mode sees:

first line of cell<special character that looks like square>second line
of cell

all on one line instead of multiple lines. But outside of data entry this
becomes:

first line of cell
second line of cell

So I believe I must have some setting for character visualization or editing
mode set somewhere. Anyone who can guide me to this thanks.
 

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

Top