If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot table cutting information of a part of the information
I have an exile file were one of the columns is a write up that needs to be
filled up by the users..This can sometimes go lebgthy upto say 9 to 10 lines...I have notices that excel is cutting off at one stage and putting a square symbol..on some entries...Other entries are cutoff without that symbol...however the smaller entries do update...Please help... Regards Anitha |
#2
|
|||
|
|||
Pivot table cutting information of a part of the information
First, those square symbols are probably linefeeds--alt-enters in the cells that
tell excel where to create new lines within the cell. You can format that cell (range of cells) to allow wrap text and the squares will disappear. If your strings in your table are longer than 255 characters (or is it 256???), then your string will be chopped. That's the way excel works. (Maybe you can add a column with a shorter description and use that in your pivottable. Then you can include any important information that was in the part that got truncated.) If your strings aren't that long, then make sure you increase the rowheight (or columnwidth) to show all the string--or use a smaller font. ASR wrote: I have an exile file were one of the columns is a write up that needs to be filled up by the users..This can sometimes go lebgthy upto say 9 to 10 lines...I have notices that excel is cutting off at one stage and putting a square symbol..on some entries...Other entries are cutoff without that symbol...however the smaller entries do update...Please help... Regards Anitha -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|