MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Switching Between Active Worksheets »


February 4, 2002

Are there any hotkeys for switching between spreadsheet to spreadsheet?

Using the Analysis Toolpack »


February 3, 2002

My colleagues can use the XIRR function, but it does not appear to be available in my version of Excel.

Differences in Excel Versions »


February 2, 2002

Microsoft is pretty good about making sure that features from one version work in the next version.

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.