Specifying column width

To specify the column width
  1. Click a column.
  2. On the Home tab of the ribbon, after Column width, type the width (in pixels).

    Optionally, right-click the column and select Column width from the drop-down list.

To auto-fit the column width
  1. Click a column.
  2. On the Home tab of the ribbon, after Scale to fit, click Auto.

    Optionally, right-click the column and select Auto-fit Column width from the drop-down list.