I am very frustrated by trying to install the "Analysis
Toolpak" addins for an Excel 2002 (running on W2K) user.
It prompts me for the installation media, asking for a
PRO.MSI file, which is not present anywhere on that media.

I have a spreadsheet full of contacts and addresses.  At
the moment it is all in upper case.  I want to convert the
whole sheet so that it is in the proper case of the first
letter upper and the rest lower case.

I am trying to upgrade by converting my Lotus files to
Excel 2002. I can not seem to get my data to fill a full
page.  I have set my right margin to zero but I am still
missing about a half inch that did print in Lotus. That is

I made a worksheet 'password protected' and now when I try
to open the worksheet, excel opens but the worksheet
doesn't open.  I don't get a prompt to enter a password.  
Can anyone help me?      Thanks,     Tommy

For some reason, Excel 2000 is now working at 97 whereby
each file is opening in the same window, having to be
accessed through the Window menu.  I am not getting
separate tabs for each file.

I have macros in the file personal.xls which is stored in th Xlstart folder
in documents and settings.  However, it has stopped loading automatically
when excel is started and I have to start it manually to run the macros in
other spreadsheets.

I'm trying to use an IF statement to perform a
calculation based on the value in a cell being equal to
any of three values.  I have =IF(A2="28819",SUM(E2*-
1),"0")   I want to be able to say that if A2="28819"

I am trying to copy a column of subtotal and paste without
the data that makes up the subtotal.  I have tried the
special paste values only but excel continues to copy all
the underlying data.

I have a macro that I would like to automatically open
when my workbook opens (no, I'm not writing a virus :)).  
I know it can be done, but can't figure out how to do it.  
I am working in Excel 2000.

I'm having trouble setting up a table in Excel so that I
can have the column headings print at the top of
subsequent pages for ease of use. I tried using Help and
page setup with no success. I know it can be done, but I

for some reason, I no longer am able to navigate through a spreadsheet by
using my arrow keys.  This is especially annoying since I no longer am able
to use the CTRL key and select multiple cells with the arrow keys.  I've
looked everywhere I can think of where there may be a ...

I customize my Excel and Word menus with those commands
that I use the most.  From time to time the customize menu
is replaced with the default and I have to reconfigure it
again.  Is there any way to protect the normal.dot and the

I have a welcomb virus on my "Microsoft Excel for Windows
95" disk 2.  Where or how can I get another disk 2?
donhorn[removethis]@ncia.net

When I click File, New I get a window that lists various
workbooks I created.  
Some of them are templates, and others are files
selected.  How can I remove and add workbooks to that

I am having a problem where we have a lot of text in a
cell.  I have the wrap text option turned on and have
made the row quite tall.  Some of the text is not
displaying.  There is plenty of white space at the bottom