MS Excel: 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

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