I have a work book with 25 work sheets. Sheet 1 contains the rate for
my formulas. Sheet 2 ( the working sheet) uses the formula from sheet
one to cost my products. In some instances there are more that 40
products that use the same rate formula. (each product requires a

I create a Name as Test = {"A" , "B"} (not a range but a list of datas)
by the menu 'Insert" / "Name" / "define"
Then i cant'use that name "Test" in the Data validation Combo box
by the menu "Datas" / "Validation" / "Option" / "Autorize" (List)

Condition:- If cell C48 is not blank AND cell C49 is blank then colour cell
C49 light yellow.
I have placed the following in condition 1 for Cell C49
   =AND(NOT(ISBLANK(C48)),ISBLANK(C49))

Its a minor point but one that is bugging me.
My excel 2000 has stopped displaying the sum of cells which I select with my
mouse and has instead started displaying the count - does anyone know how to
change this back?

I really, really like it when a company takes a stable, useful product and rewrites it so as to turn it into a flaky -- and
therefore less useful -- product. It gives meaning to my existence as a customer.
So here's the latest glitch/flaw in Excel 2007:
I have an xlsx spreadsheet. I ...

If you have numbers in a range say B4:B7 and the last row is blank, should
the function read =SUM(B4:B8) to include the blank row or ius it ok to leave
it at =SUM(B4:B7). A colleague who works in this area insists it is good
practice to use the first option. Any thoughts ...

I'm a beginner in the world of computer and ms office. On my computer  I
using Office2007. In excel Icreate a file and saved it as .XLXS file. For the
correctons of this file I send to my friend,by using a flash disk. My friend
is using Office2003. My file is not oppen on my ...

Excel 2003 is producing the following error on start-up:
---------------------------
NET Co Library
---------------------------

Hello - When I copy and paste a formula into a new column, Excel
assumes that I wanted to use references to different columns.
That is, each time that I want to copy and paste a formula into a new
column, or sheet, I have to either first make it an absolute

I have a series that contains #N/A errors results from a formula. I want to
calculate the min/max of the actuals values ignoring the error values. Any
ideas? I have tried min() & mina() but returning errors.

In an bank statement (excel softcopy) the movement description excel rows
look like this:
1 RECIBO TELEFONO       
2 TELEFONICA MOVILES S.A.       

I have a form which I developed using XL which involves inserting 'X' into a
series of boxes which in turn collects the data and generates a numerical
formula which returns a dollar value. Is there a way to have those boxes
activated with a mouse click rather than having to type ...

I am trying to remove a digit and replace it with another digit.
I.E.: A1 has '2001' in the cell... I want to change that to '9001'.
I have dabbled with =left (a1,3) to remove the '2' but cannot figure out how
to place the 9 in.

Never had this before but no matter what size I set the font on m
spreadsheet it prints out at somehting like size 8 which I cannot read
How can I get it printed in the font size I wan
--

I usually just do a control+A and hit delete but this does not remove any
formatting (font, background, borders, alignment).
Is there any quick way to do that (short of deleting the sheet)
Any help here will be appreciated.