Excel Tips


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.


Removing a Set Number of Characters From a Cell »

November 11, 2001

What I need to do throughout a big worksheet was to edit the cell, move the cursor to the end of the cell and then delete the last 4 characters if the characters.