Microsoft Excel

Microsoft Excel articles

  • excel

    How to Position Excel Graphics Evenly

    Any time that you have two or more graphics in an Excel worksheet, you want to be certain that they are distanced equally from each other because it is more pleasing to the reader’s eye. This can be easily accomplished with a few easy steps. Here’s how: Using your mouse, position your graphics where you […]

  • excel

    Here’s a Neat Excel Trick for Pasting Formulas

    Many Excel worksheets have columns and rows of identical formulas that have different formatting throughout. Now, when you edit a formula and want to copy it down your column or across your row, but don’t want to over-ride the formatting of the other cells, you would normally use a right-click and select Copy, select the […]

  • excel

    Easily Remove Hyperlinks in Excel

    What could be easier than using Paste Special to remove your hyperlinks? Here’s how: In a blank cell in your worksheet, key in the number 1. Select the cell and click CTRL + C to copy the cell contents to your Clipboard. Depress your CTRL key as you click each hyperlink you would like to […]

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