Text to large for Excel cell
So why when you expand the cell does the text not all show up?
"Sandi" wrote:
I have to do lots of queries on the different cell contents and different
sorts. Effective leader behaviour by
union/management/male/female/plant/ho/field/type/etc etc etc
"Peo Sjoblom" wrote:
Is there any reason you do this in Excel as opposed to say Word?
Anyway, if you use alt + enter ever so often you can bypass the character
limitations in Excel
which you can find in help under specifications, of course not all text will
be visible in the cell itself
--
Regards,
Peo Sjoblom
"Sandi" wrote in message
...
Doing a qualitative study and need to document the interview questions - I
require having a lot of text information in certain cells. At the moment
I
seem to be stopped at about 250 words or 2500 characters. I need it double
this size at least in some cases.
I have tried "autofit" columns, "autofit" rows and neither of those work.
Is
there a way around this? Or do I have to move to Access to work with this
data?
|