MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Hiding a Range Depending Upon User Selection »


February 11, 2002

If a control checkbox is not checked then I would like to hide specific rows and columns automatically with VBA.

Text to Columns Using VBA »


February 10, 2002

How to text to columns using VBA.

Summarize Data with Pivot Table »


February 9, 2002

How to summarize data with pivot table.

Setting Cell Font with VBA »


February 8, 2002

How to set cells font with VBA.

Validating Inputbox Entry »


February 7, 2002

How to validate inputbox entry by using macro.

Maximized View in Open »


February 6, 2002

How can I make sure Excel opens my file maximized?

Excel Autoshapes »


February 5, 2002

Free Drawing 98 application from Microsoft to jazz up the drawing toolbar with 139 easy to use symbols for Excel.

Find and Remove Strings »


February 5, 2002

Is there any way I can simply remove certain characters from a text string?

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.