Right-click FormatCells AlignmentTAB .......uncheck the "Wrap text"
box.....

If the cell value then overflows to the blank cell at the right, place a
"space" in that cell........

Vaya con Dios,
Chuck, CABGx3




"Elisabeth" wrote:

I want to be able to change the size of a cell and hide what is typed instead
of it changing the cell size to show what is typed