MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


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 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.