LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default I'll try one last time. :(

Situation: Text from another sheet is pulled into a cell. Destination cell
is too small for entered text to fit. Can't make cell larger. No real
estate left on the sheet.

I tried to format destination cell for wrap text, but that didn't work.
Entered text all goes into 1 line, "under", or hidden into next cell in next
column.

So,

.. Description Of Problem
"|| Mold wear is causing a washed out area at the radii blends ||" comes out
.. . .

.. Description Of Problem
||Mold wear is causing a wa||

Customer won't be able to read this remarks/comments column. The column
contains a formula to pull the text in from another sheet, so they can't view
the formula bar to read the text. Can't dbl click on the text, or the
formula comes up.

How do I make a text window, similar to a comment window, but have the
actual text from the cell appear when cursor huvvers over the cell?

Note: I'm asking for a comment window that reflects the data pulled into the
cell from another sheet. Not how to make a comment window with "set" text.
The text will vary, and can change as the program is run.

As corrective action takes place, that column (from original report sheets)
will be edited and updated. The destination cell here will always be the
last updated comment/description.

I just want it to be easy for the customer to see the full text line when
they need to.

Final cry for help here! This is the 4th time I've posted this over the
past 2 weeks. Plus once in two other Excel categories here. Does anyone
have an idea how to git'r dun?!?
 
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
synchronizing timestamp feature with time on video software. 999 Excel Discussion (Misc queries) 4 July 30th 06 10:49 PM
formula to determine time range overlap? William DeLeo Excel Discussion (Misc queries) 0 June 6th 06 08:26 PM
Hot key for time? Dave in Des Moines Excel Worksheet Functions 2 March 24th 06 04:15 PM
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
Entering Times Denise Excel Discussion (Misc queries) 9 November 15th 05 04:57 PM


All times are GMT +1. The time now is 03:19 AM.

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"