April 2011 - The Excel Team Blog

The title of this post sounds simple. Should be easy to do, right? But customers tell us that it's very confusing and not at all clear where to find the features to get the results they want. It all depends on what you want to merge or split. For example, you may want to create a large header cell by splitting the cells below it into a number of smaller cells. I often create such headers but use a different method than you'd expect because an individual cell simply cannot be split into smaller...

So it turns out that Excel 2010 users have something in common with Word users after all. While researching the top search terms and phrases on the Office Online web site, I discovered that just like Word users, many people who use Excel 2010 want to add page numbers, the date and time, a filename, and other text to the header or footer of all worksheets in a workbook. So here's a video I created to help you accomplish this task. ...( read more ) Read More...

People are crazy for Excel's VLOOKUP function, and why not? Among other things, VLOOKUP is known for its rugged good looks and unparalleled martial arts ability. In all seriousness, VLOOKUP is one of the most widely used, versatile functions in Excel. You typically use it to quickly look up and extract specific bits of information from a big list of data. In the following example, I've instructed VLOOKUP to search for a page ID on another worksheet, find a corresponding page name, and plunk...