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

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

Guest

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.
 
Could you just hide all of the columns to the right of those cells?

Does that help?

***********
Regards,
Ron
 
Format>Cells>Alignment. Checkmark "wrap text".

Will prevent spilling across to empty cell at right.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Need to expand Excel 2007 spreadsheet beyond column IV 2
Force text to extend beyond cell boundaries 3
How do I stop cell contents from spilling into the next cell? 4
Last Modified By in a cell by user 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Text to appear three rows after last blank cell in column 3
Truncated wrapped text cells in Excel 1

Back
Top