Microsoft Excel

Microsoft Excel articles

  • Microsoft Excel

    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

    How to Adjust Row Heights for Text in Excel 2010

    You can easily put more text into a cell than will display properly and while you can widen your column to make the text fit, there are some instances where this might not be advisable. Instead, you can wrap your text within the cell such that your cell height will be increased to display all […]

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