Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell formatting and dissapearing text
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Cell formatting and dissapearing text
Resolved · Urgent Priority · Version 2003
Reply Fri 3 Oct 2008, 09:17Delegate Matthew said...
Matthew has attended:
No courses
Cell formatting and dissapearing text
Hi, I have two problems:
1 - On one of my reports that i have opened on a colleagues computer all of the text in a cell is bunched up into the middle preventing you from reading the content - what can i do?
2 - On another report i can view the text in a specific cell (cell contents is viewable at the top of the screen). However the cell is empty. I assumed that the text colour may have been set incorrectly so i have selected black but this has not changed anything - what can i do?
For upcoming training course dates see: Pricing & availability
RE: Cell formatting and dissapearing text
Hello Matthew
Thank you for your questions and welcome to the forum.
If you have quite a lot of text in one cell, it is a good idea to use the wrap text feature, which allows you to get text to go onto more than one line and keep the text left aligned.
To wrap text, select the cell and then go to Format - Cells - Alignment and tick the Wrap text box.
Then make the cell the size that you want by adjusting the column width and row height.
Your second question is more difficult to answer as a cell either has something in it or it doesn't. If you select a cell and you can see the text at the top of the screen, then there is definitely text in the cell.
It may have something to do with the vertical alignment of the text in the cell - try selecting the cell and go to Format - Cells - Alignment and see what the vertical alignment is set to. If it is set to Bottom, try changing it to Top.
Otherwise the text might be entered in with a whole bunch of spaces at the front, which would push the text down the cell.
I hope these suggestions are useful, if not let me know.
Amanda
|