Microsoft Excel

Microsoft Excel articles

  • excel-feature-image

    How To Remove Excel Hyperlinks and Leave the Text

    This is a quick and easy way to remove hyperlinks in your worksheet without the fuss and bother of a macro. You will not believe how easy this is to do! Follow the steps below to learn how: In a blank cell in your worksheet, key in the number 1. Select your cell and click […]

  • 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 […]

  • excel-feature-image

    Extract Records From Excel Using Advanced Filter

    Many businesses use Excel to manage data that employees work with on a daily basis (i.e., invoice data, shipping records, product name, etc.). In some instances, when working with this information, it becomes necessary to extract records based on different criteria. This is a prime example of when you would use filtering. Just suppose you […]

  • excel-feature-image

    How to Remove Useless Worksheets in Excel

    So what do you do when your colleague sends you an Excel workbook with three or more pages? Well what’s the problem with that?? I will tell you – most of the time there is only one page in that workbook with data in it, which makes the other two pages useless in my humble […]

  • excel-feature-image

    How to Assign Macros to your Excel 2013 Ribbon & QAT

    Everyone wants to save time and I am a big proponent of that! I love to save time and keystrokes because it allows me more time to do the things I enjoy, like riding my bike, or knitting, or playing with grandchildren! So, one thing that has always saved me time is macros. I use […]