Hide too long text in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I hide the part of the text that is too long for the cell? This
automaticly happens when in the cell on the right is already a text. But I
want this also when there is no text in the neighbouring cell. (Note: I don't
want to use wrap text)
 
One way albeit a drudge, you can select the column next to it that has text in
only some cells, do Edit Go To / Special / Blanks, hit the spacebar to put a
single space in, and then use CTRL+ENTER to enter that in every blank cell.
 
Back
Top