How to Autofit column Width in Excel

IN excel the cells do not alway auto expand, this will show you how to make it expand so your information fits in the cell

Instructions

Difficulty: Easy

Things You’ll Need:

• Microsoft Excel
• Computer
• Data in the Excel Sheet

1. In Microsoft excel, as you fill out data into each cell, it does not always auto expand to fit your selection.
2. Excel without auto fit In the screen shot we give an example of above.
3. As you can see with it spread out it does not fit into the cell.
   This can become, frustrating for both the user entering the data, and the person who needs to read it.
4. Left Click Selection There is actually quite a simple solution to this.
   in the upper left hand corner of excel. (Screenshot Attached)
   Left Click, in the screenshot the line in the upper left represents where to click. This will highlight the complete sheet you are on.
   To the left of "A" and above the number "1"
5. Once you have left clicked and the complete sheet, has been highlighted, you will move to the next step. Which is to edit the column width
6. Format Menu To edit the column width, you will want to go to the Format menu, in 2003, inn 2007 it is on the Home tab to the right as the screenshot indicates.
7. Auto Fit Column Width Once you have the format menu up select, Auto Fit Column width.
   Image attached indicates this selection.
8. Auto fit selection complete Once complete your sheet will change. It will now take the information it the cells, and expand the cells so the information will fit.
   
   Compare this image to the first image

Tips & Warnings

• Following the above instructions will give you this result
• 2003, 1997, office may vary a little bit, but the option is under the format menu in both
• ALWAYS BACKUP DATA
• ALWAYS SAVE YOUR FILE BEFORE MAKING CHANGES SO YOU CA REVERT BACK IF NEEDED