It's amazed me that what I am trying to do is not much simpler:
   A                                          B
Jim Jones                            Jim Jones
Hank Aaron                       Hank Aaron

I've got Excel 97. It's easy to arrange summation of  data in a column of
cells.  You put in a result cell the summation formula for every column you
want to sum.  You can use the same formula for summation in rows, but do you
have laboriously enter, one cell at a time, the regular ...

Say I have two columns (A and B) containing dates and I want to know how
many days there are between the dates.  I know that if I use the formula
=B1-A1 I'll get the number of days between the dates if the formula cell
is formatted as a number.  However, say cell B1 does not contain ...

I have a simple worksheet with  column A on the left with 31 names.
After highlighting the data that goes with the names I click
Data>sort>Column A>(there is a header on top) finish. It correctly
sorts the first 24 names. The next 7 start with a another subsort of

How do you protect the macro sheet?

Exercise #35 (moving right along) had me make a chart on the same
sheet as the data. No problem. Then it says to "copy the embedded
chart to the worksheet range beginning at...."  When I click on the
chart area, it *is* selected, but I can't see any way to Copy. The

Would it be possible to have a Simple Spread Sheet that would recognise the
input of the SAME number if it were entered three times and then highlight
that number in a different place and the number could be anything between 1
and 2000

Could someone please help me out with the following scenario:
I have a column which contains various dates.  What I want to be abl
to do look at one cell and perform an IF function.  IF the cell's dat
is between this date and that date THEN do this (mathematica

I have a file that I continually add worksheets to. With each new worksheet
I have to reset the page set-up with regards to margins; header and footers
etc. I assumed that copying a correct worksheet to the new one would simply
copy over all my requirements but it doesn't.

My manager created several chart sheets on his system (currently Windows 2000, Excel 2002 I'm pretty sure...he's in a meeting so I can't get his SP#).  The
charts look good, have a couple added lines to split the quarter visually  into three months (the X-axis is the day of the ...

I know there is a keyboard shortcut to move and freeze window panes in
Excel 2000 (rather than moving the dividers around with the mouse)
because I saw someone do it once.
I forgot the keys however and if anyone can tell me what they are I

Is this site under attack from hackers?
Every time I press the Forum tab on this site... an unusual web pag
come up.
- Larry

New here.  Not necessarily new to Excel, I've assembled a few buttons
combo boxes, vlookup's.  Anyway...
I've created a set of five forms on one worksheet.  I've added a secon
worksheet for all the data to copy to, basically creating a databas

I'm using the above book and am stuck on Excel exercise #31 (page 265)
It's about a 'what-f' worksheet and introduces data tables. The
example shown in the instructional part of the exercise isn't valid,
according to the error msg I get when copying it.

I'm sure its a very obvious mistake I've made, but this is the firs
time I've attempted to use Excel.
I am typing in the following formula to find a percentage of a numbe
of values, but to ignore any values that are zero or less. The value