Excel Tips


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.


Split the Content into Two Columns »

January 31, 2002

I am trying to convert one column that has both last name and first name (LAST NAME, FIRST NAME M.I.) in it to two columns.