Microsoft Excel

Microsoft Excel articles

  • excel-feature-image

    How to Correct Capital Mistakes in Excel

    How many times have you been typing away only to glance down and discover that Caps Lock is on? Fortunately, Excel can catch these errors for you – IF I tell it to! Follow the steps below to learn how: On your Ribbon, Click the Office button and then Excel Options in Excel 2007. In […]

  • excel-feature-image

    How to Use a Custom Drop-Down List for Choices in Excel 2010

    There are many reasons why you might want to control a user’s input in a worksheet. My number one reason is that it saves time and keystrokes and everyone knows how much I love that! Another reason is that it will limit the choices and you will then be certain to get the data that […]

  • excel-feature-image

    How to Find all Merged Cells in an Excel Worksheet

    Many folks use merged cells in their worksheets and they can definitely be helpful, but many times merged cells can cause you untold heartburn when selecting ranges, sorting and other functions we use in Excel every day. Even if you do not use merged cells because you once experienced the problems mentioned above, you certainly […]

  • excel-feature-image

    How to Round to the Nearest Half-dollar with Excel

    When you are working with data that involves money and finances, you often need to round amounts to a specific point such as a dollar or perhaps even a half dollar. The tried and true method has always been to use the ROUND function with a formula like the one below: =ROUND(A26/0.5,0)*0.5 The formula divides […]

  • excel-feature-image

    How to Print Multiple Selections of an Excel Document

    Have you ever received a workbook from a colleague and wanted to print selections from more than one worksheet and have them all print on the same page? Sounds like voodoo magic doesn’t it? It can be done and doesn’t involve any crazy magic either! The easiest method to do this would be to set […]

  • excel-feature-image

    How to Hide Graphics When Filtering in Excel

    Very often graphics are used in worksheets. Sometimes the graphics are used to demonstrate what resides in the cells and that is fine. Usually graphics sort with cells well. However, when you apply filters to those cells the graphics sometimes bunch up at the top of the visible cells. Wouldn’t it be lovely if we […]

  • excel-feature-image

    How to Find Merged Cells in Excel

    Most folks will tell you that Merged cells are a pain in the butt! Why? Because they can cause you lots of problems when you are selecting ranges, pasting, sorting, and other functions. Perhaps you may be in the habit of not using merged cells in your worksheet, but have fallen prey to them in […]

  • excel-feature-image

    Excel – Some Neat Cell Tricks

    When you have large worksheets in your Excel workbooks it can be cumbersome and time-consuming to move around in them. This is a slick little trick that has existed in Excel for a very long time, but most folks do not know about it. Follow the steps below to learn how: To quickly jump to […]