software

BUMP!!!
Sorry folks but I could do with some help regarding this, as it appears
to have reared its head again!!!

Is there any way that I can hide one of the fields of the pivot?
Basically I have created a pivot with fields like Department, Level,
Location, # People... which is customized based on a particular Department
only, but i do not want to quot;showquot; the quot;Departmentquot; pivot field in the report.

Is there any known bug, spyware, or otherwise where the color pallette
is changed without any input from the user?
I just had a user complain of the colors changing. I stopped by and
everthing looked fine with the exception of the color pallette. All of

Hi there
I am currently using an Index/Match formula to match and transfer data
between two tables
{=INDEX(UPRNmatch.xls!Gaz,MATCH(O10047,UPRNmatch.x ls!Match,0),1)}.

I am trying to create a graph the compares Quantity Demanded and Supplied in
relation to a particular price to find the equilibrium (intersection).
The problem is, I have no idea how to make one row the Y scale in my graph.
and the other two (QD and QS) the two line graphs which should intersect.
For example at a price $0, the QD is 11 units and the QS is 0. At a price $

Is there a way to combine these two functions where the last 2 parameters on
the index function are dependant on the value of cells in row 1 and col A??
It is a bit difficult to understand what you want but ...
maybe this could be of any help???

I need calculated values to be displayed without any trailing zeros. For
example:
if the result is 12.0, I need it displayed as 12
if the result is 5.50, I need it displayed as 5.5
but... in a worksheet of calculated values, I need the values displayed to

Im trying to create a database on my excel spreadsheet so i can then
analyse this data using graphs etc.....
Basically i have a form with 6 fields on it. What i want to do is to
have people type in entries to this form and then click on a button to
transfer all this data accross into another worksheet under the same

Why won't the Auto Fill options button display when I drag the fill line?
Does this mean you see the popup, but almost all the items are disabled?
Do you have autofilter applied? And are you filtering your data?

Suddenly wrapped text is not displaying in Excel. I can select the cell and
see the text in the function bar that it is in the cell and if I turn off
wrapping it displays. None of this text is very long. Thoughts?
How long is not very long?