How to organize large amounts of data in 1 cell

[maria123]

Hi all,

Hopefully an easy question for you...

I am doing a spreadsheet for work that will require a lot of information to be entered into a single cell. As there will be a lot of rows I do NOT want to enlarge the cell from it's regular size (15 height), but rather, I would like to only see the first few words that fit into the cell until actually selecting the cell - where it would expand and show the full paragraph I have typed... is this possible? I could've sworn I have seen this before but have searched internet etc for hours and cannot find how. I am using excel 2007.

Thanks in advance

From "In dire need of assistance"

 

[Datsmart]

I think using "Outline/Grouping" in Excel will do what you are after.
Do a search on that topic in this forum and see if that will work for you.

 

[crusader]

Hi all,

Hopefully an easy question for you...

I am doing a spreadsheet for work that will require a lot of information to be entered into a single cell. As there will be a lot of rows I do NOT want to enlarge the cell from it's regular size (15 height), but rather, I would like to only see the first few words that fit into the cell until actually selecting the cell - where it would expand and show the full paragraph I have typed... is this possible? I could've sworn I have seen this before but have searched internet etc for hours and cannot find how. I am using excel 2007.

Thanks in advance

From "In dire need of assistance"

Are you referring to
Home -> Format -> Format Cells -> uncheck (untick) Wrap text

or
increasing the size of the formula bar by clicking the bottom of the Formula bar and dragging it down?

 

[skyreacher]

hey there,
I have read about Microsoft Excel and would like to share some information, regarding your problem. You can check out the links below and they might be some help to you
"http://www.techyv.com/questions/microsoft-excel" this provides guidelines for using Excel.
http://www.techyv.com/questions/only-second-line-multiple-line-texts-seen-cell" Here you can find some guideline regarding texts being shown if multiple lines are entered in a cell.

 

[maria123]

Are you referring to
Home -> Format -> Format Cells -> uncheck (untick) Wrap text

or
increasing the size of the formula bar by clicking the bottom of the Formula bar and dragging it down?

Hmm... I'm not too sure what either of those mean... When you open a blank excel sheet the cells are formatted in their generic way (the small squares which I would like to keep)- When I type a lot of information into one of these cells which would be under a particular heading it enlarges to wrap around the text which enlarges the whole line (including the other cells on these lines). Most of the information I am putting into each column is 1 or 2 word answers which fits nicely. I don't want the large paragraph that I input to effect the whole line... Rather, I want to be able to see the first 1 or 2 words in the cell, and when I highlight the cell, I want it to enlarge to show the whole paragraph. That way when looking at the spreadsheet without anything highlighted you can still see a lot of the information, and if a client wants more indepth info on this particular housing project they can highlight the cell to show the specifics. Hopefully this makes sense.

The issue in trying to find "how to's" online is to try and fit what I want in one sentence lol.