Microsoft Excel

Microsoft Excel articles

  • 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

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

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