Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
How do i set default column type as text in excel? | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |