Say you have a large contact list in Excel that is formatted, for example like: Column A - Names, Column B - Addresses, Column C - Cities, Column D - States, Column E - Zip Codes. It's great that everything is formatted in neat columns, but it would be a nightmare if you wanted to use this list to print off envelope address labels. Thankfully, there's a macro can speed up this … [Read more...]

Do you want to have a list of information in all CAPITAL LETTERS, all lower case, or All In A Title Format? This would be an extremely tedious task if, say you have 100+ lines that need to be updated. With these macros, you can select the cells you wish to update and change their case in a flash! Note: These macros won't change the output of a cell with a formula in … [Read more...]

We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes this produces undesired results. Empty cells could play tricks on certain features in Excel, such as pivot tables, that read an empty cell as 0. If we don't want these cells to appear in … [Read more...]

We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes this produces undesired results. Cells that may appear empty really aren't, as they will often times contain spaces. Usually this isn't a problem, but sometimes pivot tables or other … [Read more...]

Have you ever set the fill color of an entire sheet (or workbook) to white just because you didn't want to see the gridlines? Well if you have a large file, you could literally reduce the file size in half by not coloring the cells. Simply remove the gridlines (after all that's what you wanted to do in the first place isn't it?). Copy all of the code below. Paste it into … [Read more...]