Excel: AutoFit Column Width format functionality

I’m sure you guys have seen this before when copy/pasting datasets into Excel (probably for the business?):

Well there is great format functionality in Excel 2010 (propably also in 2007) which I didn’t know:

Ok, first select the entire Excel-sheet by hitting CTRL-A.
After that….you’ve probably guessed it already…hit the AutoFix!

The result after:

That really saved me a lot of time 🙂

Advertisements

One thought on “Excel: AutoFit Column Width format functionality

  1. Pingback: Link Resource # 56 : May 24 – May 30 « Dactylonomy of Web Resource

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