SSMS will size the columns of the width for the data that is displayed on the first page in the grid. To expand the size for the rows you are currently looking at, you can double-click on the split between the column and the next column in the column headers, just like you do in Excel.