Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

Illustration

share|improve this question

2 Answers 2

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

 
discard

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.