I am using MS Excel 2003.  How do I copy a formula all the way down a column
without copying the data inside the cell too?  When I entered the formula in
the second cell of the last column and got my total.  I copied the formula in
the cell and went down.  It copied the formula ...

I am assisting in a complex multi-country NGO project which requires careful
planning, but a simple to use template where action points can be easily
changed/ added and tracked month by month . Really just a 12 x 7 box
structure, maybe in excel than people with very basic ...

Is it possible to hide a value in a single cell. If so, how would I do this?
Thanks.

I have a problem trying to set up a worksheet using SLN function to show a
straight-line depreciation and a formula to determine the annual rate of
depreciation. Cost=$96,345; Salvage=$25,000; Life= 6 yrs; Annual Rate of
Depreciation = SLN/Cost.

Dear experts,
I have columns with expiry dates for first aid certificates.  How do I
change the colour of the cell to alert me to the fact that the date for
renewal has arrived.

can anybody help to solve it out...
if D4 is not a blank cell, then G3+E4-F4. if it is blank then look for G2 is
not a blank cell, then G2+E3-F3
Thanks,

I am working on an Office 2003 worksheet which determines a grade for users.
Grades are based on scores and are graded as shown below.
          GD1                    GD2                GD3               GD4
GD5

How do I write this formula I have been given the first part but cant
work out the rest myself
=IF(A1<>"",8.26,"")
If A1 is blank make b1 blank if A1 is not blank put 8.26 in B1 also if

I need to create a payment function to display a positive number and a
formula for the total interest. It's 5% rate, time 3, loan 12,000. Also how
do I do status? what lookup funtion?

My predicament:
Excel is the only available medium on our network. I have to show a breakout
of manpower daily and email daily.  We also maintain a history to show
attendance in the past.  I'm trying to automate this process.

I am looking to link cells horizontally so that when a drop down box (list
box) is used and it locates a particular entry that has been selected, it
subsequently populates all the cells for that entry horizontally as well as
the the selected entry from the drop down box.  Say the ...

I am looking to put a search box or something similar that pops up or is
fixed on the spreadsheet somewhere that you can search for a cell by entering
a word opposed to a cell reference and then it will highlight that line or
cell on the spreadsheet, any ideas???

How would I go about hiding rows as a result of a blank in column
A(there is a formula in columnA which gives a blank) and a 0 in column
B, there is blank cells between 4/3/07 and 5/3/07. I would most likely
only do this at the time of printing as the user does not see this

How to use Excel to do likelihood ratio chi-squared test?
I know I can use the "Chitest" function to do chi-squared test, but I have
no idea how to do likelihood ratio test using Exel functions.

Hi I hope someone can help me with this I want to run this on a sheet
carlog before printing but I cant work out how to put the print
routine in, anyone!!!!
Sub HideRows()