View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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.