Any computer bods out there? I know how to "wrap text" on an excel spreadsheet but it seems that after 15 lines (or so) the writing just tails off out of the box and nothing i do can get it into view. i often need to store lots of info for work within cells and this is making it harder to read. any advice welcome. thanks!
2006-12-21 02:50:45 · 8 answers · asked by sarsa 2 in Computers & Internet ➔ Software
i am assuming that you are selecting the cell, going into format and telling it to wrap text. You then need to adjust the size of the column to see all the text...
2006-12-21 02:53:32 · answer #1 · answered by Naveen S 3 · 1⤊ 0⤋
It's difficult to know your level of expertise from your question, but there are pretty much only two possibilities - you need to resize your cell, or you have reached the charcter limit for your version of excel. Resizing a cell can be achieved most simply by clicking-and-dragging on either the edge of the column label or row label; cell character limits for your version can be easily googled.
If you want to preserve the look and feel of your workbook but are constrained by character limits, perhaps you could fill adjacent cells with the same colour and make it appear as if this was a single cell?
2006-12-21 03:00:34 · answer #2 · answered by johninmelb 4 · 1⤊ 0⤋
Depends on the Version of Excel. 2003 allows more characters in a cell (65536 I think). Or try manually stretching the column width and row height to view your data.
Alternatively, use a text box
2006-12-21 02:54:40 · answer #3 · answered by PhoenixRights 4 · 0⤊ 0⤋
An Excel spreadsheet is normally used for calculations and little text.It will only take a number of characters on a line or lines. but will take lots and lots of numbers or calculations.
thats why you are having problem.
A word document is mainly used for letters or lots of text.
2006-12-21 03:02:35 · answer #4 · answered by **tomtom 5 · 0⤊ 0⤋
First Select the cell to wrap text, then go to fomat menu and select cell option. Go to alingment tab and then tick the wrap text option. Hope ur problem will resolved.
2006-12-21 03:05:49 · answer #5 · answered by Tanmay 1 · 0⤊ 0⤋
try doing your text in "word" first, then copy and paste it onto the spreadsheet. you may have to adjust some row/column sizes afterwards to make it fit exactly where and how you want
2006-12-21 20:00:44 · answer #6 · answered by guitarman 1 · 0⤊ 0⤋
I am currently working on excel programs in school, and I haven't been able to. I don't think that you can.
2016-05-23 05:12:39 · answer #7 · answered by Anonymous · 0⤊ 0⤋
Format your cells.
Justify is one way.
2006-12-21 02:53:46 · answer #8 · answered by ROBSTER 4 · 0⤊ 0⤋