MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


Create In Cell Column Chart »


November 27, 2001

How to create an in-cell chart to illustrate a percentage.

Merge Rows Quickly »


November 22, 2001

Is there any way to merge two rows together quickly?

Formatting Time Values »


November 21, 2001

Adding zeroes to time values by using macro.

Changing Cell References »


November 20, 2001

Changing cell references by using OFFSET function.

Copy To Next Blank Row »


November 20, 2001

I want to have Excel copy an entire row to a new Excel worksheet based upon a cell entry.

Creating Proper Names »


November 19, 2001

How to capitalize the values in a particular column.

Graphing in Excel »


November 17, 2001

If you create a chart in a worksheet, you may find that you don't like some of the chart options set by Excel as default.

Data Validation »


November 16, 2001

Drop-down list on one worksheet where the list of valid cells is on another worksheet

Parsing with Characters »


November 15, 2001

When you are typing custom number formats, you can insert any single text character by preceeding it with a backslash.

Excel Crash on Mouse-Over of Object »


November 14, 2001

I have a document that has become very unstable. Every time that my mouse gets near one of the red comment triangles, Excel will crash.

Convert Multiline Data To Rows »


November 13, 2001

How to convert multiline data to rows.

Celect Random Numbers from a Column »


November 12, 2001

Select 5 random numbers from a column of 50 numbers.