How do you change column width to fit the contents?
A. single-click boundary to the left to the column heading
B. double-click boundary to the right of the column heading
C. press Alt and single click anywhere in the column
D. all of the above
Answer: Option B
Solution (By Examveda Team)
To adjust a column width to fit its contents in Excel, you can:Double-click the boundary to the right of the column heading.
This action automatically resizes the column width to match the longest entry in that column, ensuring that all data is visible without manually adjusting the width.
Options A and C are incorrect because:
Option A: Single-clicking the boundary to the left of the column heading does not adjust the width.
Option C: Pressing Alt and single-clicking anywhere in the column does not affect the column width.
This Question Belongs to User Ask Question >> Miscellaneous
Answer is b. You click doubly on the right of the column heading and drag on the other side