View - Max. Displayed Column Width

Ribbon bar. Select the View tab. In the Display group, click Max Column Width and from the menu...

Classic menus. From the View - Max. Displayed Column Width submenu...

..select the maximum width (in inches) of columns (variables) in the spreadsheet. You can select 8, 6, 4, 3, 2, 1.5, 1, .75, .5, or .25 inches. If you prefer, select Customize to display the Custom Max Column Width dialog box, in which you can specify a different width.