cell formatting and dissapearing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell formatting and dissapearing text

Cell formatting and dissapearing text

resolvedResolved · 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


 

Excel tip:

Cycling through Absoulte cell references

If 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.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.09 secs.