Please Help: EXCEL EXPERT (Texts in spreadsheet)

reandle

JF-Expert Member
Joined
May 6, 2009
Posts
11,166
Reaction score
8,159
Guys, am preparing excel spreadsheet with more texts than numbers. Tatizo ni kwamba, hizi texts zipo in multiple paragraphs ambazo zimekuwa prepared kwenye word processor. Problem ni kwamba, nikizi-amisha from word processor to excel spreadsheet, zile multiple paragraphs zinatokea in multiple cells... which means, kama kuna 10 paragraphs, kutakuwa na ten cells to cover the those 10 paragraphs. It appears like this:

Wakati lengo langu hizo multiple paragraphs ziwe frozen in a single cell, like this:
​
So, yeyote ambae ana utalaamu wa namna gani naweza ku-format hizo columns please let me know. Kama nilivyosema, lengo ni kwamba hata kama ni more than 1 paragraph basi zikae kwenye one cell.

Thank you advance guys.
 
Rafiki I am not an expert but try this ,right click cells you want to use,click format cells,click wrap text, there ! see I this is what you want!
 
And if this is not cool do same procedure but instead of choosing wrap text take merge cells option,all of this you get from alignment tab .
 
Rafiki I am not an expert but try this ,right click cells you want to use,click format cells,click wrap text, there ! see I this is what you want!
Thank you very much Ali but the problem already solved... but for the benefit of other users, the process starts by double clicking the cell to be used, then paste the content (which will enlarge the cell); thereafter you follow the procedures you outlined above (and un-tick wrap text option(in Alignment tab).
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…