Answer:
1. By double-clicking on the column separator.
2.By selecting Column width from the home tab
3. By setting to the default width
4. By selecting Autofit column width
Explanation:
All of the above tricks are going to work. Please try them now. However, in the case of 2. and 3., we need to mention the width, and hence they are seldom used. Most of the occasion we double click on the column separator or we select autofit option.
Answer:
There are two ways to change the width of the column.
Explanation:
Method I
In excel sheet, to adjust the column width according to entered data in the cells, Just double click in the top most cell's right border. This process will  automatically adjust the cell's width according to largest entered data in the cell's of that particular column.
Method II
In second method we can change the width of the column manually. In this method, just click on the right or left border of the column and hold the click button. Now move the mouse to left or right to adjust the width of the column.
