Hide most of the data in a cell

  • Thread starter Thread starter Akilah
  • Start date Start date
A

Akilah

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a table from Word 5
Hide Some Text in a Cell 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Customizing the Display of Data in an Excel Cell 2
Can Excel enter page breaks to always follow a merge cell? 1
Hiding cells based on the value in another cell 3
Change all text on Spread sheet 1

Back
Top