I suspect you have found one of bugs in Excel.
A workaround you could do is make the caption in column A right justfied and only contain the first three characters.
Then make a caption in column b that is left justified and contain the rest of the caption for column A.
>Dear Yuri
>
>Thanks for the Reply.
>
>But if I make the Column Autofit my Last Few Columns will go on Next Page which I donot want and every Column is Set of Four which will break the Group.
>I only want to repeat the Serial No Column with the same Width but in the SubTotal Row as there is space in the Right side I want to Display the complete
>Caption.
>
>
>Thanks
___________________________
Kenneth Wonderley
http://www.wonderley.com...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23