LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default pasted HTML text disappears



Thanks Jean_Guy

That was the first thing I thought too, but the font is black on a white
background.
To double check, I tried to pasted it into a .doc and it pasted fine.

However, in EXCEL, I have to double click the mouse to get the text to
appear.

I just noiticed that when I do that, most of the options, on the standard
options toolbar, selected from the "View," go gray.

Opening "View," on the Menu, when the only choice that isn't gray is
"toolbars.".

For the cell that keeps hiding, at the input box at the top of the page,
where a "=" is entered to indicate the cell contains a formula is active and
shows, an X, a check mark, and the = sign.

However, for the cells that show text, that area is gray and empty. When I
select one of those cells, all the options that gray out when the "blank" row
that contains a header and has to be double clicked to get it to show, return.

So, we are still unsolved on this problem. Oh, I also checked to see if
anyting was hidden and it wasn't.

More help is needed to figure out how to simply paste the headers in a cell,
without having them disappear unless I double click the cell and keep the
curson in it.

Thanks, Bob

"pinmaster" wrote:

Hi,

Probably white font on white background........try changing the font color.

Hope this helps!
Jean-Guy

"sunslight" wrote:

I copy from a web page, part of a document that has section headers, plain
text, hyperlink text.

I paste it into Excel--just a straight paste with the mouse. I'm not using
the "Edit | Special" because I want to preserve the hyperlinks.

It all seems to be there, except for the seciton headers.

The rows that they are on are there, but nothing is visible.

However, if I move my mouse into the cell and dbl click, the text appears.
Move it out of the cell and it's gone.

It's a neat trick, but not very useful if I don't know how to control it.

What I want is to have the headers show up, just like the rest of the
document.

(btw) it copies fine into Word.

Ideas?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct issues SteveDB1 Excel Worksheet Functions 25 June 3rd 09 04:58 PM
Copy from a Cell to a text box. AJL Excel Worksheet Functions 9 November 7th 06 04:58 PM
Imported Text from two HTML tables looks same but is different bman342 Excel Discussion (Misc queries) 0 June 24th 06 06:12 PM
text disappears from document to excel gregp22 New Users to Excel 1 March 20th 06 04:51 PM
How can I make Excel display HTML code as text roopytoopdongle Excel Discussion (Misc queries) 1 March 20th 05 06:40 AM


All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"