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
