Remove and Prevent Automatic Hyperlinks in Excel

  In the past, I highly recommended the Excel newsgroups as a place to go for help. Earlier this month, Microsoft shut down their newsgroup servers, where thousands of people every month had gone to post their Excel questions. Over the past several years, I spent lots of time in those newsgroups, reading and answering…

For your amusement, here’s a word search puzzle that’s filled with the names of Excel worksheet functions. You can work on it at the office, and if anyone asks, just tell them you’re working on some complex Excel functions. Or, print out copies for all of your co-workers, and use it as an ice breaker…

Where is Excel headed? On the Forward Thinking CFO podcast, Brian Jones (Head of Product, Excel) discusses Microsoft’s strategy for Excel. There are two 30-minute episodes, and you can listen to both of them below.

Here’s an Excel question from today’s mailbag. MK asks: I am trying to use countif to find the number of times a word exactly appears in a column – e.g. count the no of times “PACK” appeared in a column excluding “pack” etc. I remember seeing a combination of countif and exact functions used in…