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

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.

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

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

Does that help?

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


"GetVigilant-Jon" wrote:

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.

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

FormatCellsAlignment. Checkmark "wrap text".

Will prevent spilling across to empty cell at right.


Gord Dibben Excel MVP

On Wed, 23 Nov 2005 13:40:08 -0800, GetVigilant-Jon
wrote:

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.