98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Cell formatting and dissapearing text
Cell formatting and dissapearing text
Resolved · Urgent Priority · Version 2003
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?
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
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. |
Excel tip:Cycling through Absoulte cell referencesIf you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key. |