ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide most of the data in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/182895-hide-most-data-cell.html)

Akilah

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.

Gary''s Student

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.



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

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