Excel Tips
Change All Caps to Proper Text »
May 1, 2002
How to change the case globally so that it is properly formatted.
April 30, 2002
April 23, 2002
I have an Excel spreadsheet that is hundreds of pages long and many columns wide.
Counting Cells by Interior Color Using VBA »
April 17, 2002
How to count cells by interior color using VBA.
Filename Derived From A Cell »
April 16, 2002
How can I write an Excel VBA macro to save the current Excel file with a filename derived from cell A1?
Splitting The Contents of a Cell »
April 16, 2002
How to split the contents of a cell in to columns.
Expand Excel Chart Using Drag Drop »
April 9, 2002
Here is a cool & easy Excel charting tip for those of us who must re-do Excel charts each week, month, quarter or year to reflect a new data point.