Resize Columns


In this topic you will learn how to Resize Columns.


Steps:

  1. There are two options available for resizing columns:

     

    1) Manually enter the appropriate column width, or

    2) Utilize the Excel - Auto Fit option.

     

    In this example both options will be demonstrated.

    Step 1
  2. Click the B column to highlight the entire column.

    Step 2
  3. Click the Format option.

    Step 3
  4. Click the Column Width list item.

    Step 4
  5. Enter the desired column width.

     

    Enter the desired information into the Column Width field. Enter "45".

     

    NOTE: You may have to repeat this option until the column width is correct.

    Step 5
  6. Click the OK button.

    Step 6
  7. Excel can determine the correct column width for you by using the Autofit option.

     

    Click the Column Heading you wish to resize.

    Step 7
  8. Click the Format button.

    Step 8
  9. Click the AutoFit Column Width list item.

    Step 9
  10. The system automatically resized column B.

    Step 10

This completes Resize Columns.

Table of Contents  Start Topic