Wednesday, February 4, 2009

Welcome and today's bug

Welcome!  I have to say first that I didn't come up with Excel Ninja, but I like it, so it stays. :-)  I started doing work in Excel and VBA almost by accident, and now, spend 1/3 of my time at work on Excel based solutions.  I wouldn't say I'm an expert, or even that great at it.  But I enjoy doing it and have learned quite a bit along the way.  Hopefully I can share some of that knowledge here, as well as ponder other ponderables such as my first bug report...  Enjoy!


I have to say that for the most part I really like Excel 2007, but it has some bizarre bugs and missing functionality.  Bug of the day - can't unhide columns.  I hid some columns, then went back to unhide them and no luck.  No worksheet or workbook protection, just hidden columns.  I select the entire sheet, then right click > unhide, nothing.  I select the columns to the left and right, same thing.  So, I turn to my friend Google (slightly ironic that one of Microsoft's biggest competitors offers the best help when things go wrong!).

I found this link that solved my problem: "Perhaps the column isn't actually hidden, but its width is very small. Try selecting columns to left and right and use Format > Column > Width, putting something sensible (say 8)."

I already knew that hiding a column is the equivalent of setting it's width to zero, but why not be able to unhide?  Who knows, but it worked.  I've got my columns back, but I am still quite baffled.

Am I way off base here?


  1. Hi Jayson,

    There's a change that takes place around a width of .04-.05

    Setting the width to .04 will let you unhide it. Setting it to .05 actually preserves the width at that when it is set to visible. Don't know why, it just is.

  2. @Ken:

    Thanks! The oddities abound!