MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Subtotal Without Grouping »


October 15, 2001

I have a column of numbers that I want to add. But I want subtotals for each person who may have more than one number.

Text Value Response to Input »


October 15, 2001

Your ace pitcher starts to look weary in the 6th inning and then gets in trouble in the 7th inning. Can you show me a formula in Excel to tell if I should pull him out of the game?

Automatically Get the Date and Time »


October 15, 2001

Is there a way to get the date and time automatically by creating a formula?

Formula to Add Years to a Given Date »


October 14, 2001

Using DATE() function to add years to a given date.

Open a Userform When a Workbook is Opened »


October 13, 2001

Use Workbook_Open to open a Userform when a workbook is opened

Locking Cells to Protect Critical Data »


October 12, 2001

Need to find a way which can create a command that makes the cursor jump from one cell to another after pressing the enter-button.

Excel Time Series Chart »


November 21, 1999

The Excel data that I have needs to be plotted against time down to the minute. The Excel data points are randomly spaced, so there is not an equivalent amount of time between each data point.

Convert Feet and Inches to Decimal Feet »


February 7, 1999

In Excel, learn how to take a single column of feet, inches, and fractional inches and use the custom function Feet () to convert to decimal feet and back. This Excel user-defined function will make it easy to convert between measurements that are easily human-readable and convert them to measurements which are good for calculating. MrExcel will teach you how to use a customer function to do the conversion in Excel.

Excel 97 introduced new User Forms. In English, teach me how to create and use a list box. »


January 17, 1999

Like many of you, I started writing Excel macros in Excel 5.0. This whole Macro Editor in Excel 97 is a bit intimidating. For this week's tip, I will show you, step by step, how to create the list box for this project. The focus this week is just on the combo box.

Convert Excel Days To Months »


November 21, 1998

I want to use an Excel pivottable to summarize the data, but I want to see it at the month level instead of at the daily level.