hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    Which menu allows setting a specific column width in MS Excel?
    Question

    Which menu allows setting a specific column width in MS Excel?

    A.

    Home → Cells → Format → Column Width

    B.

    View → Zoom → Column width

    C.

    View → Column width

    D.

    Insert → Column

    Correct option is A

    In Microsoft Excel, the option to set a specific column width is available on the Home tab of the Ribbon. Within the Cells group, the Format drop-down menu provides the Column Width command. This command allows users to enter a numeric value to define the exact width of a selected column, ensuring proper alignment and visibility of data in the worksheet.
    Important Key Points:
    1. The Column Width command is located under Home → Cells group → Format in MS Excel.
    2. It allows users to manually specify the exact width of selected columns.
    3. Adjusting column width helps ensure proper visibility of cell content.
    4. This feature is part of the cell formatting options available in Excel.
    Knowledge Booster:
    · View → Zoom → Column width: The Zoom feature changes the magnification level of the worksheet, not the width of columns.
    · View → Column width: The View tab in Excel controls display options such as workbook views and zoom, not column width settings.
    · Insert → Column: The Insert command is used to add a new column, not to modify the width of an existing column.

    Free Tests

    Free
    Must Attempt

    SSC CGL T-I Similar Paper (Held on 12 Sep 2025 S2)

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt

    SSC CGL T-I GA Section Test 01

    languageIcon English
    • pdpQsnIcon25 Questions
    • pdpsheetsIcon50 Marks
    • timerIcon15 Mins
    languageIcon English
    Free
    Must Attempt

    SSC CGL T-I Full Mock Test 1 (Exam Level)

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon200 Marks
    • timerIcon60 Mins
    languageIcon English
    test-prime-package

    Access ‘DDA SO’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    383k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow