My first two rows in my spreadsheed is my header. How do I make thi
header stationary while I scroll
--
keepers

I have a large workbook with two types of sheets.  One type has detailed
info. and is always named after a five-figit number.  The summary pages
are titled things like "summary" or "overview".  I have around 100
detail pages and about 15 summary pages.

I've got a spreadsheet that I need to modify.
There are some cells that have drop down 'text' boxes associated with
them that are activated only when the cell is selected.
There is no indication on the cell that there is a 'comment' attached -

Hello,
I am new to the forum, and have what I expect to be a rather simple
question to answer.
I work with several excel worksheets that are prefilled with default

I am attempting to re-work an existing worksheet that contains cells
that have been "named".  Does anyone know how to change or delete a
name once entered into the "Name Box"?  When I attempt to write over
the names, I receive and error message regarding references.  Thank

I had Office 2003 installed, then installed Office 2007 as well. The
system was automatically configured then to open all Excel files (2003
or 2007) in Excel 2007.
However, here at work they just did some Office 2003 update, and now

I created a sales order excel spreadsheet with 997 lines, then I autofilter
down the info I want the other depts to see. (One gets to see the prices, the
other dept doesn't) If I just E-mail the worksheet that protects the data,
the margins, etc don't transfer and what should ...

HIYA

im trying to set up a list of ratios.  if i have a list of numbers in
b1:b20, and i know that b1 corosponds to the nuber in c1, is there a
way to solve for the numbers that should be in c2:c20. i cant just drag
it down, becuase it just copies the same number. i want to basically set

I'm trying to run the following code in an Access function in order to
run an Excel macro. The problem I have is that I wish to close the
excel workbook but with changes saved. If I add in the line
'objExcel.Save' before the close command it throws errors saving do you

Good day,
I was wondering if any one could help me with a problem.
My column A contains dates in a dd-mmm-yy format.  Column C contains a
number of events that took place. I am trying to count the number of

Trying to do a calculation to count the number of people who are aged between
30 and 40 have their dates of birth in a table trying to get the formula to
work because it has to be greater than one date AND smaller than another????
=COUNTIF(B2:B97,"<30/05/1976",>=30/05/1966")

when i try to autosum a column of numbers, what im getting is the formula in
the cell and not the sum. anyone know why this is  happening? thanks in
advance

I've got a column full of numbers like 0.5, 1.0, etc. I need them to look
like 0.500%. I figured out how to format the cells so that 0.5 looks like
0.500, but when I change the cell format to percentage, it makes 0.500 into
50.000%.

When I open Excel and click the 'File' menu item, a drop-down list of most
recently used files appears, as is normal in Windows programs. In Excel
however the list is usually wrong. It usually omits the files which I have
used most recently and lists only ones which I used some ...