I have downloaded a chart for my daughters diabetes. When i view the tab bar
it shows there is only 1 "sheet". However if I scroll down the side bar it
shows there are over 200 pages to this chart, but apparently 1 sheet. It is
fine except when I forget to print just pages 1-1. ...

how do i create amortization tables in Excel 2003

I have just started using MS-Excel. I was wondering what is the maximum
number of worksheets that can be inserted in 1 MS-Excel Workbook?

how do I configure Excel 2002 to create an automatic backup copy when I
create a new file or edit an existing file.
Thanking,
Ron Patterson

I am a newbie in excel and having a problem with
countif function.
Currently in the actual worksheet I was unable to
set a CountIf formula with multiple criteria.

Searching for the solver examples on the net I came across the example where
I find a formulae that I don’t understand and I just wonder if any one could
explain in very simple words the formulae is
=B14*MAX (B10, 0) ^$H$4

How do I remove a dotted border, that seems to delineate pages,
from my spread sheet?  I appeared out of the blue, but probably the
result of me accidentally selecting something.  Maybe during print.

I have a spread sheet created with Excel 2007. One colum has first and last
names in all caps. How can I convert the first letter for each name to be
caps and the rest of the letters to be lowercase? I want to do the whole
colum at once.

I have a pretty simple worksheet that lists the date in column A.
In column B, I have a formula that converts the date in Column A to
the proper day of week.
When I put it in a pivot table, it treats column B as an individual

I am trying to copy a formula down a column.  I have done it for years and
worked fine.  This time, the first result appears in each cell, but if you
look at the formula in copied cells, they show the correct formula has
changed as I dragged it down the column.  

Good morning everybody,
I have looked through a few groups and I haven't been able to find
what I need to do, so here goes:
is there a standard function/formula that allows you to reference the

Is it possible to share an excel worksheet - have two users make corrections
at the same time?

How do I use the autofilter to sort a list

This ordinary Excel formula: SUMPRODUCT((x = x )*(y = y)*(z = z),(A:A)) can
be replaced by array formula: {SUM(x = x)*( y = y)*(z = z)*(A:A))}.  
Both formula will produce the same result.  My question is that what is the
extra advantage on "array formula" over the ordinary formula. ...

I'm using Excel 2000 and windows 2000 professional.
This started about two days ago:
When I double click on an xlt file, my computer returns:
Cannot find the file 'K:\Customer Service\Quote\Cost Roll-up.xlt'(or