Microsoft Excel articles
When you are working with data that involves money and finances, you often need to round amounts to a specific point such as a dollar or perhaps even a half dollar. The tried and true method has always been to use the ROUND function with […]
How to Round to the Nearest Half-dollar with Excel Read More »
Have you ever received a workbook from a colleague and wanted to print selections from more than one worksheet and have them all print on the same page? Sounds like voodoo magic doesn’t it? It can be done and doesn’t involve any crazy magic either!
How to Print Multiple Selections of an Excel Document Read More »
The use of macros in Excel is made possible by the VBA programming language and we tend to avail ourselves of it often in our workbooks. We do this because we want to do things within our worksheets quickly and efficiently. Every time we create
How to Remove the Enable Macros Warning from Excel Documents Read More »
Very often graphics are used in worksheets. Sometimes the graphics are used to demonstrate what resides in the cells and that is fine. Usually graphics sort with cells well. However, when you apply filters to those cells the graphics sometimes bunch up at the top
Most folks will tell you that Merged cells are a pain in the butt! Why? Because they can cause you lots of problems when you are selecting ranges, pasting, sorting, and other functions. Perhaps you may be in the habit of not using merged cells
Suppose you had values in Column A of your worksheet and a list in Column B. There is a conditional format that makes any value in Column A turn red if it is also in Column B and you want to sort or filter by
How to Use Excel Conditional Format Results to Sort and Filter Read More »
You can easily protect the formatting of your worksheet without it affecting your data or text. Follow the steps below to learn how: Select all the cells in your worksheet. On the Home tab or your Ribbon in the Cells group, select Format Cells to
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
Many businesses use Excel to manage data that employees work with on a daily basis (i.e., invoice data, shipping records, product name, etc.). In some instances, when working with this information, it becomes necessary to extract records based on different criteria. This is a prime
Extract Records From Excel Using Advanced Filter Read More »
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,
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
How to Assign Macros to your Excel 2013 Ribbon & QAT Read More »
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
How to Adjust Row Heights for Text in Excel 2010 Read More »
As you know, when you select a cell in your worksheet in Excel, you can see the contents of that cell in your Formula Bar. If, however, the content is longer that what can be displayed in a single line on your Formula Bar, the
This tip may not be for everyone, but for those who write macros in VBA and have a need for it, it will certainly be appreciated. Sometimes when you are creating a macro in VBA, there comes a time when you need to determine the
How to Determine the Day of the Year with Macros in Excel Read More »
