ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What happened to my formatting? (https://www.excelbanter.com/excel-discussion-misc-queries/233806-what-happened-my-formatting.html)

Eric

What happened to my formatting?
 
In Excel 2003, I have a cell with text. I've applied character formatting to
a couple of words in the text. But when I hit Enter, it disappears.

When I now select the cell and hit F2 to edit it, I can see the formatting
that I applied. But then I then hit Enter, and it disappears again.

What's happening to my formatting? Why can't I see it?

Thanks.

Shane Devenshire[_2_]

What happened to my formatting?
 
Hi,

Do you mean you can't see it on the Formula bar or in the spreadsheet after
you press enter?

If you mean on the Formula bar - you never see it there even if you format
it there.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Eric" wrote:

In Excel 2003, I have a cell with text. I've applied character formatting to
a couple of words in the text. But when I hit Enter, it disappears.

When I now select the cell and hit F2 to edit it, I can see the formatting
that I applied. But then I then hit Enter, and it disappears again.

What's happening to my formatting? Why can't I see it?

Thanks.


Eric

What happened to my formatting?
 
I can't see the formatting in the cell on the sheet after I press enter. Not
the formula bar.

The cell contains a couple of sentences of literal text. I've highlighted
one word in red bold. I can only see the red bold it when I select the cell
and hit F2 (edit), and the formatting reappears in the cell. But when I hit
enter, it disappears.

I can't figure out why. (I even checked to see if maybe I had applied
conditional formatting to the cell and forgot about it, but no.)


"Shane Devenshire" wrote:

Hi,

Do you mean you can't see it on the Formula bar or in the spreadsheet after
you press enter?

If you mean on the Formula bar - you never see it there even if you format
it there.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Eric" wrote:

In Excel 2003, I have a cell with text. I've applied character formatting to
a couple of words in the text. But when I hit Enter, it disappears.

When I now select the cell and hit F2 to edit it, I can see the formatting
that I applied. But then I then hit Enter, and it disappears again.

What's happening to my formatting? Why can't I see it?

Thanks.


Melissa in Salem

What happened to my formatting?
 
On Jun 14, 8:41*am, Eric wrote:
In Excel 2003, I have a cell with text. I've applied character formatting to
a couple of words in the text. But when I hit Enter, it disappears.

When I now select the cell and hit F2 to edit it, I can see the formatting
that I applied. But then I then hit Enter, and it disappears again.

What's happening to my formatting? Why can't I see it?

Thanks.


Check to see if you have white as the font color. And I do hope it's
something that easy!

Eric

What happened to my formatting?
 
Alas, no. The text mostly has font color Auto. There's one word where I've
applied font color red, using the Font Color button on the toolbar.

"Melissa in Salem" wrote:

On Jun 14, 8:41 am, Eric wrote:
In Excel 2003, I have a cell with text. I've applied character formatting to
a couple of words in the text. But when I hit Enter, it disappears.

When I now select the cell and hit F2 to edit it, I can see the formatting
that I applied. But then I then hit Enter, and it disappears again.

What's happening to my formatting? Why can't I see it?

Thanks.


Check to see if you have white as the font color. And I do hope it's
something that easy!



All times are GMT +1. The time now is 07:00 PM.

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