Two question:
1. I want my excel spreadsheet to shade every other row automatically?
2. When I use filter, can the excel re-shade every other ro
automatically?

when i'm doing caluclations in excel, i want to "show my work". I dont
mean just showing the formula (eg. =A10 + B20, you can do this if you
copy/paste the function in the cell). But instead, say if the value in
A10 is 1 and B20 is 2, i want it to show "=1+2" in the cell.

i would like to be able to automatically put the current date in the
cell only when something is entered into another cell, but I when I go
back to the worksheet I don't want that date to update to the current
date I just want it to show the date that the information was entered.

I'm basically a newbie to Excel and only create very basic spreadsheets with
basic function.
(I'm using Excel 2002)
I've creating a simple spreadsheet to keep track of finances. I'm having

We have a "Quote Calculator" that we setup in excel to calculate the cost of
getting some custom products.  We want to show the customer the results of
that calculator, but we don't them to see the calculator itself (i.e. the
breakdown of charges).  How could we hide and protect ...

Ok, here is my problem:
I have a range (say A1:B3) and I am using something like this:
For Each c In Range(A1:B3)
I=I+1

I have two columns. One with dates and one with names:
09/22/77      Jane Doe
I'm trying to sort these by months so I can keep track of people's
birthdays.  Is there a way to do that?

how do I make the column labels repeat in a spreadsheet?  When I follow the
help directions, I am unable to "enter the row numbers" I keep getting a
message that it is an invalid entry.  What am I doing wrong?

I'm trying to input some currency symbols specifically;
Japaneese Yen Symbol
British Pound Symbol
Swiss Franc Symbol

I exported a spreadsheet from another program. One of the columns lists
names i.e. Mr and Mrs Smith.
there are around 250. Half of them are in Uppercase which means if I do a
mail merge I have to change them which will take a long time.

Afternoon All,
Ive never written a macro before.  So excuse me if this is dead simple.
With VBA how can I create a macro that when I select an entire row with the
mouse then run the macro.  It selects the next 3 entire rows below then,

I have created a calculator in excel for the purpose of quickl
checking whether people who have employed us as a subcontractor hav
deducted the correct amount of cis tax, but there is one thing i can
get quite right.

I don't know what I'm doing wrong. All I'm trying to do is add a column of
numbers. In cell L13, my formula is =SUM(L2:L12). All I get back is 0. I've
checked the formatting of the cells and they are all numeric. I have also
tried adding cells manually, e.g., =L2+L3  -- and I get ...

   I have one issue when i get the data through the pivot table
option. after creating a pivot table, i enabled the sub-total and the
grand total in the pivot table properties. after enabling that the
sub-total and the grand total columns appear as #VALUE!.

Can someone please help me with this one :
I want my formula to sum all there is in column "F" only if its colum
B=1 and its column C<10000  :
SUM.IF (AND(B2:B43 = 1);(C2:C43<10000); (F2:F43))