| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide most of the data in a cell
I need a way for a cell to contain a paragraph but I want it to show only the
first word until the cell is clicked. Is there a way to do that? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide most of the data in a cell
For all of the paragraph except the first word, format the font the same
color as the background color. Thus only the first word will be visible. However, if you click on the cell, the entire paragraph will be visible in the formula bar. -- Gary''s Student - gsnu200777 "Akilah" wrote: I need a way for a cell to contain a paragraph but I want it to show only the first word until the cell is clicked. Is there a way to do that? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide the data label for a data table in a chart | Charts and Charting in Excel | |||
| How do you hide the value of a cell until data is keyed into anoth | Excel Discussion (Misc queries) | |||
| Trying to either hide data in a cell or reduce the data to zero | Excel Worksheet Functions | |||
| I want to hide values if no data in target cell | Excel Worksheet Functions | |||
| Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
