Learn more

Changing the order of the spreadsheet columns

Changing the spreadsheet column headings

Eliminating excess column width on the spreadsheet (Best Fit Column)

Making spreadsheet columns non-scrolling

Turning spreadsheet columns on or off

Changing the size of the spreadsheet columns

To change the size of the spreadsheet columns:

  1. Place the cursor on the right border of the column heading.

    The cursor should look like this Column resize icon.

  2. Drag the cursor to make the column narrower or wider.

Tips:  

  • When you enter large numbers in a column, the column expands to accommodate the entry. If you enter a smaller number later, the column does not shrink to fit the smaller entry.

  • You can eliminate excess width in one or more spreadsheet columns using the Best Fit Column feature.

    To eliminate excess column width:

    1. Use the mouse to select one or more column headings.
    2. Click the right mouse button and select Best Fit Column from the shortcut menu.