I am setting up a spread sheet which has long columns, but when I am
entering the figures well down the spread sheet I keep forgetting what
column is what, can I have the header row float down the spread sheet with
me all the time.

What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.
Yes, I know I can just subtract but is there a formula that can do it?
Marguerite

does anyone get the "disk is full" error in Excel 97 when saving file in the
network server?
the error occurred when saving whatever the file size is small or large.
I am running Excel 97 SR-2 with Windows 98. The other ppl using XP does not

Thanks for your previous invaluable help, and it seems I need it again.
I have the following formula in a spreadsheet in Cell E7
=IF((ISBLANK(D7)),"
",(IF((OR(ISTEXT(C7),(ISBLANK(C7)))),D7+TIME(7,0,0),(IF(D7<MOD(C7+TIME(12,0,

All,
I'm new to using macro's within Excel, please forgive my ignorance in
advance! heh
Does anyone know the best way to color cells within a worksheet based

How can I set the sheet size to, say, 40 cols x 60 rows? Tried setting all
other col's to 0 width but panning still brings me into the uncharted grey
region where they used to be.
Thanks,

I am new to excel. I have been tasked with creating a work schedule for 20
people on a previously established excel spread sheet/ schedule. However, it
was for the last academic year and therefore the dates for each given weekday
are off. Is there any way that excel can ...

I would like to have a cell either fill with a color or have an x inserted
or something.  It doesn't matter what goes into the cell.  I need to set up
a column with cells that when I click on them they change.  I am trying to
get out of having to type the word yes in every cell.  ...

I would like to have a cell either fill with a color or have an x inserted
or something.  It doesn't matter what goes into the cell.  I need to set up
a column with cells that when I click on them they change.  I am trying to
get out of having to type the word yes in every cell.  ...

I'm importing a web page into Excel.  The web page contains a table of
file info such as PRIMARY  |  SECONDARY |  FILE NO.
I import all 3 columns OK, apart from some instances of file number.
At times, the file no. translates incorrectly to a date e.g 10/3 ends

Our company have a Korea Branch, I attempt to set a Macro for WON, but it
does not work. When I run the macro, it reveals "?4,455". (if the cell is
4455)
Attach please find the macro.

I am using 'vlookup' and 'match' functions that result in #VALUE!, but when
I hit function wizard, it shows the correct number value I am looking for
and expecting in the result area.  Apparently my syntax, etc. is accurate.
Why, then, does #VALUE! show up when everything is ok?  ...

I tried to make a Pivot Table do the following:
"Show me the right value - copy the value to a Temporarily worksheet"
I tried the code shown below. How ever it keeps on giving me the same error
in:

Many of my references link to another work sheet and "paste special" gives
me absolute values but you can't at least that I know of use these easily in
"sum".
Marc

Using Excel XP.
I am doing a baseball stat spreadsheet and I have pitchers names in column A
and in column B I have a W (for a win) or L (for a loss).  What I want to do
is to check column A for a pitcher's name, e.g.  "Schilling" and then to