How to Make All of the Columns the Same Size in Microsoft Excel

Using a Mouse
1. Open the Excel worksheet with data in columns.
2. Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.
3. Hover on the line between any two selected column letters--it doesn't matter which two--until you see a black symbol with two arrows pointing in opposite directions. Click and drag left to make the columns narrower or drag right to make them wider. All the selected columns should now be of equal width.
Using the Menu
4. Open the Excel worksheet with data in columns.
5. Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.
6. Click the 'Home' tab, then click 'Format' in the Cells section.
7. Select 'Column Width' from the menu.
8. Enter a number in the box provided and click 'OK.' You can specify any number between 0 and 255; this represents the number of characters the column will display.