MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


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.

Adding Every Other Cell in a Column »


January 24, 2002

Is there a quick way of adding every other cell?

Convert Seconds to Time Format »


January 23, 2002

How can I format a cell that has data in seconds to show it as hours:minutes:seconds?

Enter Time Without Colon »


January 22, 2002

Event Handlers in Excel.

Keep Excel Window in Focus »


January 22, 2002

When I call Help without using the assistant (F1) Excel resizes itself to allow the Help window and the spreadsheet to be visible at the same time. Is there anything to prevent this?

Working with Dates »


January 21, 2002

How to fill a column with the last date of the month, starting with the last date of one particular month.

Finding the Average Between Two Data Sets »


January 19, 2002

I'm trying to calculate the median of salaries with a particular job code within a large set of data... something like a Sumif function but to calculate the median.