TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)

Please be sure to mention the version of Office you are using when you send your question.

I answer all e-mails that I receive via this form, as long as they are polite :)

Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.

Well, when it comes to working with numbers, the answer is no -- there really isn't anything Excel can't do. At least, I've been wrong whenever I thought there was something it couldn't do.

However, there are many things you can do in Excel that can only be accomplished with the use of VBA. Two of my very favorites are both available on the KB: extract data from an Excel chart and sum only the visible cells of a worksheet.

If you've ever needed to edit an Excel chart that's been disconnected from its data source -- you know the pain! Once complex chart data is lost, it's gone! But a simple macro can get all of your data back. Check out KB article 300643. It's for Excel 2002, but works just as well in 2003 -- and contains links to similar articles for earlier versions. Here's the link: http://support.microsoft.com/default.aspx?scid=kb;en-us;300643

If you often work with hidden columns or rows of data, you know it can be frustrating trying to sum just the visible data in your worksheet. The SUM function sums all data in a given range -- hidden or not. KB article 213313 provides the custom function to sum only visible cells. It's written for Excel 2000, but works just fine in newer versions. Here's that link: http://support.microsoft.com/default.aspx?scid=kb;en-us;213313

If you have favorite custom functions -- or know of other great Excel lifesavers, please share them! Or if there's something you need Excel to do but don't think it can, send me an email or post a comment and I'll try to help.