I have this function entered in a cell:
=SUM('X1:X30'!A1)
it sums values of all A1 cells from sheets between X1 and X30.
The problem is if I insert rows in these "X" sheets (because the

Does anyone know how to create formulas to display the word "High" in the
color blue (bolded) with profit margins over 40%?
I know how to apply conditional formating, but it asks to apply conditional
formating to different cell, not the cell that contains profit margin

How do I tell which cells I have formatted as locked in an excel worksheet
without looking at each one individually?

I would like to calculate the difference between two cells.  For example:
       A                             B                              C
Amy J Hespen    Amy Hespen    Amy Hespen
Andrew Fries    Andrew Fries   

I would like to capture a date once only.
Here's the scenario:
1)  Cell A1 and cell A2 are blank
2)   A user inputs a date in Cell A1.  I want to capture that date in

I added a calculated item in my pivot table. It generated lots of lines with
zeros that did not exist before (indeed the result of my calculation is zero
since there is no data); and even, if you double-click on the generated zero,
you can see that there is no data behind.

I am doing an excel spreadsheet and need to enter some details into a cell
but I would like the cell to be split in two within the same colum.  Is this
possible?  How do I do this?

Good morning,
How can I make the now() function static?
What I am trying to do is we submit our timesheet every week.  I have a
macro set up to write the date that submit in Cell F1 using now().  The

Please help
I am currently completing an invoicing spreadsheet which contain dropdowns.
As the person that originally created the document has left the business I
have no one else to ask. I can create drop downs with only one problem, the

Hello! I have a small problem. I want to search a value in an array and
return the value true or false. I tryed with "if", "and", "not", but a
strange thing happends: when I press the function button to see if my formula
is wrong, it seems that the formula is corect, but when i ...

I am taking a statistics class and was trying the examples to calcualte
ANOVA. I tried to select the addins to update the program but I am getting a
message that wants me to install from the Office 2000 Professional SR-1. I am
running Office 2000 for Small Business, how can I get ...

are everyone know how to hide the function we made in the worksheet ?
Thanks

hi guys , this is my problem:
i got 5 worksheets in a workbook and now i am creating another
worksheet that
is the summary of all the 5 worksheets.The 5 worksheets are named 1-5

I am in the process of creating a Pivot Table however, I get an error message
saying there are too many fields. My question is:
Is there a limit to the number of fields one can have in a Pivot Table? If
there is, what is the maximum number allowed.

I know my way around Excel pretty well, though not an expert.
I have created my  an Excel file with information for each player in a
sports league whose playing rights is held by one of our teams. Essentially,
the file serves as a crude player database with the following column