Fill Text To Excell 2010

One of if not the most valuable functions of Excell is to enter into a Cell what could be several lines of text, and then close the Cell so that only the first line or first words are visible, for example an address.

Selecting and opening the Cell expands the Cell to reveal all of the contents.

This way, we are able to keep Cells which could all contain varying text lengths, all the same size.

Open the Cell to show all of the contents, close the Cell to show only the first line or words.

Simple, can anyone tell me how to do this please.

Thank You

Vegaone

Not sure exactly what you are looking for. I've attached 2 possibles.
In Rows 1-6, I used Excel's Grouping (Outlining) function to group rows 2-3 and 5-6 so they can be opened or closed (click on the +)

In 9 and 10, I simply made the cell height big enough to show a single line, formatted the cell alignment to "Vertical: Top". If you click on the cell you can see the entire text in the Formula box in the toolbar, assuming it's opened wide.

If neither of these is what you are talking about, can you explain a little better? Do you have an example?

Typically, the formula bar only opens up to 3 lines. Maybe there is a way to automate it with programming (VBA). I will ask around. You can adjust the height of the formula bar by grabbing the top of the header bar (i.e. right above "F") and pulling it down until you have what you think will be the maximum number of lines you will need. I did that with the attached example.

I don't think the elongated formula bar will carry over to your computer, you'll need to grab and drag the header yourself when you want to use it. That means it won't carry over between computers either. Hmmm