How do I hide text beyond the last column in Excel?

G

GetVigilant-Jon

In the last column of spreadsheet, if the text goes beyond the column
boundary, how is the text truncated in the next cell. I know you can enter
blanks in the next column, and that will achieve the desired effect, but
that's not an optimal solution for us.
 
R

Ron Coderre

Could you just hide all of the columns to the right of those cells?

Does that help?

***********
Regards,
Ron
 
G

Gord Dibben

Format>Cells>Alignment. Checkmark "wrap text".

Will prevent spilling across to empty cell at right.


Gord Dibben Excel MVP
 
Top