Excel cell text overhangs column edges

[Jerrycurl]

A friend of mine has an Excel file that she says used to look right until someone installed some things on her computer, and now it doesn't look the same. The problem is that the text in some of the rows overlaps the left and right edges of the cell (the text is centered). This only happens in "design" view; the text fits inside the column on paper and in print preview. It's a hassle for her because she has to flip back and forth between design mode and preview mode to make sure everything looks right, and she insists it wasn't always that way. She can't just widen the cells because the sheet is going to be inserted into another document and the width is just how it needs to be. We've tried playing around with the screen resolution and that didn't help either. Anyone have any suggestions?

 

[firefytr]

That is a common side effect of text in a cell which overlaps the width of the cell. If your friend is insistent on the data matching the cell boundaries, there is an option of merging the cells (select cell, press Ctrl + 1; or right click cell and choose Format Cells...).

I must warn you though, that is about all merged cells are good for. They can prove disastrous, troublesome at the very least, if you end up incorporating (or if you already have) VBA code into the workbook.

Good luck.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[KenWright]

Different font or font size perhaps?

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------