How can you resize a column in an Excel sheet?

Can the columns be resized in an Excel sheet ?

Intermediate Asked on 21st June 2015 in Excel for Windows.
Add Comment
  • 4 Answer(s)
    Best answer

    Three ways:

    1. Click on the border on top of the sheet and move it to increase or decrease the width.
    2. Double click on the border on top of the sheet to auto align the cells to the width of the data. You can also select a few columns before you double click to auto align them all.
    3. Right click on selected column and select column width (as shivakumar6787 said).

    Explorer Answered on 22nd June 2015.
    Add Comment


    Right Click on Selected column and click Column width

    Explorer Answered on 21st June 2015.
    Add Comment

    “Alt+O+C+W” then you can mention required size number

    Enthusiast Answered on 24th August 2015.
    Add Comment


    you can invoke 2003 Access key command to autofit the column width according to the cell characters.

    ALT+O, C, A

    Where ALT+O: to Activate format Option
    C: Column Selection
    A: Autofit of Column WIdth

    Enthusiast Answered on 30th August 2015.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.