I want to lock all of the cells in all worksheets that have formula's.  I
have 26 pages and the formula's are in the same cells on each page.
I want to protect the formula's but the only way I can find to do this is by
protecting one page at a time.  So everytime I need to change ...

I have an MS query that import certain records based on parameters entered by
the user. No problem here.
I created the report using the wizard, I selected the range based on the
parameters that I entered. The problem is that I do not know the possible

I have the following array formula, works correctly for me in cases where
both input values are nonblank, but i don't get the result i need if one or
the other is blank.  Here's the formula:
{=SUM((data!A11:A61-AVERAGE(data!A11:A61))*(data!B11:B61-AVERAGE(data!B11:B61)))}

Please tell me how to stop Excel from Adding 1 to my data when I copy it from
the first cell in a column to the rest of the cells in the same column.  For
example, when I key WC123 and try to drag & copy this value to the cells
below, the result is WC124, WC125, etc..

I have a spreadsheet that I have created that includes many formulas,
conditional formatting, and links.  I brought up the spreadsheet today and
nothing was calculating automatically. I went to the Tools drop down and
under Options I noticed that the Calculation method changed ...

Forgot to save a new file
Shut down computer
Opened Excel and hoped to see a file (a la the function in WORD) that was
unnamed that I could open with the data and then save as.

I have been wondering about this for some time.  I'm doing a lot of
work with probability and statistical distributions these days, and
many of the classes or types of distributions have different parameters
which characterize them.  For example, standard distributions tend to

I have an alphanumeric column for which I am attempting to filter for all
numeric between 1-9. If I try "greater than or equal to 1" AND "less than or
equal to 9" I get NO rows, even though there are values from 1-9. Even
trying just "less than or equal to 9" returns no rows.

I've spent a good while searching thru forums and websites trying to
figure this one out, so I'm hoping that someone who knows how to make
this work will chip in.  
I work with aircraft arrivals to worldwide destinations, so lots of

If i use one filter on my spreadsheet and then use the data - filter - show
all feature it works ok but when i have used more than 1 filter and try to
show all after finishing using the filters Excel freezes on me - i am using
Excel 2000.

I have a large column of numbers which look like this ;
I can't figure out how to insert the decimal. Have tried formating cell
and have used the FIXED option (which works on the entire page not on
the one column)

Question: Once you've applied a filter to a spreadsheet, is there an easy way
to save the filtered results into another workbook (so that the hidden rows
are deleted in the new sheet)? I basically need to create a new file, and I
don't want to jump through the hoops of linking to ...

Some of my stydents have entered numbers into cells or done a summation of a
series of cells and they get ###### signs in place of the actual
number...when mousing over the cell with the ###### a fly out appears with
the actual number. How do we make the ###### signs appear as ...

Hi, i just joined this group. I am new to excel and am trying to match
trades from two clients. The problem is that the trades are named
differently and thus require some type of pivot table or vlookup to
solve the problem. I would appreciate if someone could give me some