Excel Tips


Running Total in Adjacent Cell »

February 1, 2002

How to keep a running total of the numbers I put in a column.


Split the Content into Two Columns »

January 31, 2002

I am trying to convert one column that has both last name and first name (LAST NAME, FIRST NAME M.I.) in it to two columns.


Add a Percentage in All Cells in a Range »

January 30, 2002

How to add a percentage in all cells in a range.


Event Macro To Change Excel Header »

January 29, 2002

How to get the path where the document is filed indicated in the header or footer - or anywhere in the document.


Using InputBoxes »

January 29, 2002

Sometimes, the InputBox function just isn't enough, you need to let the user point to a cell instead of having to write in what you want.


Changing Cell Background Color »

January 28, 2002

How to modify the background color of a cell using VBA.


Multiple Lines in Message Box »

January 27, 2002

How to break an expression of Msgbox into 3 lines and insert a blank line into such an expression.


Linking Dropdowns with Data Validation »

January 26, 2002

One good use of Data Validation comes when there's a need to link two or more dropdown list, making them dependant.


Ranking without Repetitive Ranks »

January 25, 2002

How to use RANK without repetitive ranks.