Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I enter a long string into a cell it (the string) is normally displayed in its whole, taking a part of the next cell area. Line A (1) on the picture below is an example.

If I enter a long string into a cell it (the string) is truncated and a red triangle is placed into the cell to indicate this if the next cell contains any data. Line B (2) on the picture below is an example.

I would like to turn off this behaviour (truncation) to acheive the effect illustrated by the line C (3) of the picture (I've produced it with a graphics editor now). Is this possible? If yes, how?


share|improve this question

Right click on the cell and select Clear direct formatting.

share|improve this answer

I ended up deleting the cell contents by selecting it and then right click 'delete contents'. I then re-pasted the content back in and it no longer truncated.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.