Microsoft Excel

Microsoft Excel articles

  • excel

    How to Add the Day of the Week to a Date in Excel

    A lot of folks seem surprised when they enter a date in Excel and it is not displayed in the manner it was keyed in. Unfortunately those same folks try to remedy this by keying in an apostrophe before the date. That will make the date display the way you keyed it in, BUT, yes, […]

  • excel

    How to Flip a Drawing Object in Excel

    If you have ever had a drawing object in your worksheet and wanted to flip it either horizontally or vertically and didn’t know how, this article is for you! Follow the steps below to learn how: Click on the object you would like to flip and Excel will place handles (that look like small boxes […]

  • excel

    How to Set the Width of Row Labels in Excel

    Sometimes you just have gigantor Excel worksheets – there’s no getting around it! Now if, in your gigantor worksheet you also have graphs based on your data, you may find that at some point when you are scrolling through your worksheet that redrawing of your graph(s) will greatly slow down your scrolling. Now if you […]

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