Microsoft Excel

Microsoft Excel articles

  • excel

    How to Highlight Duplicate Values in Excel

    In past versions of Excel, there was a several-step process using a COUNTIF formula in Conditional Formatting to highlight duplicate values in your data. Starting with Excel 2007, however, finding and highlighting your duplicate values suddenly became a lot easier to manage. Follow the steps below to learn how: On the Home tab of your […]

  • excel

    How to Draw Borders in your Excel Worksheet

    Usually one would add borders around a cell or range of cells in their worksheet by selecting the cell or range and using the Border tab of the Format Cells dialog box. BUT, there is a nice little shortcut that saves you time and keystrokes and who wouldn’t want to do that?? Follow the steps […]

  • excel

    How to disable in-cell editing in Excel

    Excel, by default, will allow you to edit your cell information in either the Formula bar or in the cell itself. You simply select your cell and click F2 or double click on your cell. However you may wish to disable the editing feature in your cell. Follow the steps below to learn how: Display […]

  • excel

    The Transpose Feature in Excel 2013

    Transposing (i.e., swapping columns, rows, etc.) is an old trick in Excel and I am happy to report that it is still available to you in Excel 2013! As you will see in my screenshot below, I have a worksheet in Excel that is vertical in orientation, using a column style. So go ahead, and […]

  • excel

    How to Control Display of Page Breaks in Excel 2010

    There are two types of page breaks that can appear in your worksheet in Excel 2010. Those would be Manual and Automatic. As you know, you insert page breaks manually by clicking on the Breaks tool in the Page Layout tab in the Page Setup group on your Ribbon. Automatic page breaks are those that […]

  • excel

    How to Easily View Formulas in Excel Cells

    On some occasions, your Word table can contain formulas that are too long for the smaller cells in your table and that prevents them from being displayed completely when you look at your field codes rather than the results of your field codes. Word does not have a feature like the ones available in Excel […]

  • excel

    How to Protect an Excel 2010 Worksheet

    There are some occasions when you would like to prevent your colleagues from making changes to your cells or perhaps you do not want them to have the capability of seeing your formulas in the Formula bar. Fortunately, Excel will allow you to do this and more, but unfortunately, it is not always intuitive where […]

  • excel

    How to Quickly Filter Data by color in Excel 2010

    Excel has always been a great piece of software but Excel 2010 has even more great features and one of them is the ability to use a right-click cell menu to filter a table based on the active cell’s value, font color or fill color. If you color code data in your cells you can […]

  • excel

    Center Printed Excel 2010 Worksheets

    When you work with small worksheets they sometimes look out of kilter when you print them. The reason for this is that Excel prints worksheet data from the upper left-hand corner. To make your worksheet more pleasing to the eye, you can center your data horizontally, vertically or both if you like. Follow the steps […]

  • excel

    How to Turn the Excel Chart Legend On or Off

    As you know, when you create a chart in Excel, a chart legend is automatically created right along with your chart depending upon which type of chart you are creating. It doesn’t have to be that way. You have a choice. Follow the steps below to learn how: Click once on your legend to select […]