Excel text wrapping problem

  • computer
  • Student
  • Student
  • User avatar
  • Posts: 74

Post 3+ Months Ago

Hi all,
I have some simple text data in defferent cells inside excel worksheeth But when I select any cell ,formula bar shows all text but not inside the cell i.e. wraping is not working and It only showing few lines ,not all.

I have tried many ways to solve my problem but in vain.

1. I select cell-->format-->cells-->alignment-->checked wrap text-->OK :(
2. I select cell-->format-->row-->autofit-->OK :(
3. I select cell-->format-->column-->autofit selection-->OK :(
4. In last ,I manually tried to increase the width of row but content remain at the same level i.e. still not showing hidden text.

There are around 189 words without spaces (ms word count value).I am using office 2003.
Any idea to solve this problem ?

Thank you
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Don2007
  • Web Master
  • Web Master
  • Don2007
  • Posts: 4924
  • Loc: NY

Post 3+ Months Ago

I'm not an excel expert but I used to merge the cells when the data exceeded the cell size.
  • computer
  • Student
  • Student
  • User avatar
  • Posts: 74

Post 3+ Months Ago

Thanks for reply Don,

hmmm So there is any limit of no.of words per cell ?I was thinking about it thats why I calculate the words and posted in my post.

I will wait for few more expert comments.I know ATNO have some interest in excel.:)

....
  • Don2007
  • Web Master
  • Web Master
  • Don2007
  • Posts: 4924
  • Loc: NY

Post 3+ Months Ago

It's not so many words per cell as it is characters. Are you sure you need to use Excel and not MS Word? What type of information is being put in the spread sheet?
  • computer
  • Student
  • Student
  • User avatar
  • Posts: 74

Post 3+ Months Ago

Hi Don,
Sorry for late reply as I formatted my pc.You know ,there is nothing in formatting the pc but taking back up of all your program files,bookmarks,stored passwords and local server data and reinstalling of all those is very tedious work.Still I forgot to take the backup of some of my stored yahoo messenger files :).
At last,my pc is fine now.
But this is the beginning of another problem :)

I installed new version of appserv (apache)server 2.5.10 and am facing few problem.OK let me handle it first.

Now about my previous post
Don,I have very simple text data i.e. some of my notes integrated between spreadsheets of same workbook with few external links(pics)in same folder.

Well I did what you suggested above-cells merging .

regards
  • Don2007
  • Web Master
  • Web Master
  • Don2007
  • Posts: 4924
  • Loc: NY

Post 3+ Months Ago

Ok, good luck with Apache.

Post Information

  • Total Posts in this topic: 6 posts
  • Users browsing this forum: No registered users and 40 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.