Excel tips: Auto fit cell/column to text/numbers

Microsoft Excel is full of surprises. Today while working in it I realized a simple yet tedious work ahead of me. It so happened that I had to copy a tab/sheet full of numbers and paste it into a new spreadsheet. When I did that I noticed the numbers were larger than the default cell size. Therefore all I could see was ‘########’!! Since the sheet was full of numbers, double clicking on the column header would have taken a long time. I googled and found some solutions:

OPTION 1:

Select the whole sheet (CTRL + A) or a part/section of it as necessary:

Press and hold ALT key; then press ‘O’, then ‘C’ and then again ‘A’ keys. Once those keys are pressed release ALT key.

ALT + (O,C,A) keys

OPTION 2:

Select the whole sheet (CTRL + A) or a part/section of it as necessary:

Press and hold ALT key; then press ‘H’, then ‘O’ and then again ‘I’ keys. Once those keys are pressed release ALT key.

ALT + (H,O, I) keys

OPTION 3:

If you like using mouse too often then go for this option:

Make your selections and use this navigation: HOME > Format > Autofit column width

MS Excel: Fit to cell or colomn

OPTION 4:

This is the simplest option if your data table is small or with only few columns.

Select the columns that you want from the header; keep your cursor right in the middle of the last column header (of your selection) and the column header next to it. You will see your cursor turn into a header pointer/marker …..something like that 😉 Double click! Your columns will autofit your numbers into the cell.

MS Excel: Fit to cell or colomn

I tried the first option for a change and Bingo! Cells adjusted itself to the text/numbers that were in-there or more correctly, the columns expand so the texts/numbers within the cell can stretch their legs as far as they can and be visible! This, simplified my work. Hope it helps you as well. Good luck!

Advertisements
This entry was posted in Excel tips and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s