Problem? Solved.

Excel Column Sizing Magic

Posted by gayle on June 17th, 2007

Here’s a question to ponder. How many minutes in your lifetime have you spent sizing columns in Excel? Move…where’s the skinny cross arrows? No, not the fat plus thing, no, not the down arrow – I want the two skinny arrows so I can size my column. I’m getting those ##### things in my data fields. I think the spread sheet is cussing at me. I feel the same way. What? There’s an easier way to size columns? Tell me!

I discovered this great tip watching my partner at work. I couldn’t believe how easy it was and how much time it saved. How did I miss this cool feature after 10 years of working in Excel.? Oh yeah – WIKIWIL (pronounced wikeewill), what I know is what I like. I’m finding what I don’t know might save me time. OK, I’ll share it with you now. Don’t blink or you might miss it.

TIP: Place your cursor in the header column on the right border edge of the column you want to size. Wait until your cursor changes to the two skinny cross arrows, and… double click. That’s it! The column automatically sizes to the largest entry in the column.

I felt really stupid when I saw that. But now I’m greatful and use it all the time. What a carpal tunnel saver! Try it out.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>