Quick question: doing a project where I need to copy looooong items into
small cells. Is there any way I can get Excel to only display the part
that will fit in the cell? As it is, the data (text) spills out over
adjoining cells, making it difficult to see which cells to the right of
the one I'm currently working on are blank. (The data is *contained*
within one cell, I know that: it's the display I'm concerned with here.)
Any way to deal with this?

And no, I don't want to (can't, actually) resize the cells. They must
remain their present size.