Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

August 2010 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • =VLOOKUP (uhh…now what?)

    Today’s post is brought to you by Anneliese Wirth, a writer on Office.com. On Office.com , the term “VLOOKUP” frequently bubbles up in our list of high-volume search queries. My job is to figure out why this is and what specific information people are actually looking for when they type “VLOOKUP” into the search box in Help or on our web site. The “VLOOKUP” query appears to represent a bunch of different questions. Certainly, one of the main ones has to do...
    Filed under: , ,

  • You Asked: What the heck is Scroll Lock

      This week’s post is written by Amy Miller. Amy is a writer for Office.com. She’s written and edited content for Excel, Access, OneNote, and InfoPath.   Imagine you’re working in a spreadsheet and you innocently press the arrow keys on your keyboard to move to another cell, but instead of moving to another cell, the entire spreadsheet moves. You may have asked yourself, what the heck just happened, and how do I make it stop? Lucky you. You’ve encountered that pesky little problem called...
    Filed under: ,

  • Excel Web App leads to healthier snacks for kids

      Today’s blog post is brought to you by Roxanne Kenison. Roxanne is a writer on Office.com who writes primarily about Office Web Apps and Office Starter.     My son starts Kindergarten this fall. I’m excited, but a little sad that our days of co-op preschool are over. Our local community college sponsors a co-op preschool program where parents run the preschool. Each parent works one day per week in the classroom, rotating through a series of jobs. We use an Excel spreadsheet to keep...

  • Got lots of text in a cell? Make it readable

      Today’s blog post is brought to you by Gary Willoughby. Gary is a writer on Office.com who has created and edited content about Excel, Access, and Project.     Sometimes, I find I have text in a cell that spans far past its own column or…yikes, maybe even off the screen. Because I tend to be a little borderline compulsive, that bothers me just a bit. Of course, if I autosize the cell by clicking the column border on its right edge, all the cells below that cell could end up being...
    Filed under: ,

  • Use SUMPRODUCT to find the last item in an Excel list

    Today’s author is Charley Kyd, an Excel MVP, who describes how to use the SUMPRODUCT function to find the last sequential item in an Excel list. Charley has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. You can find more useful tips and posts from Charley and other Excel MVPs at his website, ExcelUser.com . Suppose you have a Sequential List of items, as in the second table here. And suppose you want to show the date...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.