Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) |