I'm using Excel 2000 on a Windows XP SP2 computer.  I have created a
simple spreadsheet, with lots of data regarding my exercise routine on a
treadmill. There are several headings at the top of the page, such as
minutes, miles, calories, and comments . So far, the spreadsheet is ...

during training exercise i cannot click on freeze panes it is not highlighted

Here's my problem...
I have a worksheet that lists football players, positions and ratings
for each player. I have another worksheet that has sections setup for
each position(QB,WR,RB,etc..). What I would to be able to do is have

I would like to know how to export a list of adresses from an Excel
worksheet to Outlook.
The problem seems to be in naming the range of data.
The top row of the worksheet contains colum names like Name, Address,

Is there a function or a quick way of coverting kilos into Stones and
pounds?
Thanks

I have a list of names out of abc order and I don't want to type them again
so how do I put them in abc order without re-typing?

I'd like to have a formula in a cel display its resultstring in multiple
lines:
e.g. if I have the following formula: ="First line of text" & Char(13) &
"Second line of text"

I currently have a template linked to various other books.  There are many
links and not always reliable due to row insertion etc.
I would prefer to consolidate into a pivot table, with different vies for
the diffent data I require.

i have a little problem with Pivot table when it comes to manual
background colouring. I wish to seek some help please.
The problem is :
if customer 1 has 1 row of data, if Row 1,column 5 is highlighted as

Text = "Receipts from:"
Date = 10/5/06. (This date will in a different cell and will change every
month)
The decription I desire will be: "Receipts from: "1st to 5th October" or any

I am running into an problem with my users.  We have a Excel 2000
spreadsheet.  I know that typically, the sheet/cell that is selected
when a user closes the spreadsheet will be the same when a user opens
the spreadsheet the next time.  However, the problem I am seeing is

This morning I was teaching a basic excel class using an older version
of Excel (probably 2000?)and had an embarrassing incident.
We were discussing how to use the fill handle to update formulas.  The
exact example is as follows:

I am running Excel 2003 on XP. In C:\Program Files\Microsoft
Office\Office11\XLStart I have book.xlt, book1.xlt (my custom workbook)
and personal.xls. When I open Excel, at the top it reads personal.xls.
Shouldn't it read book1? Macros run fine. Anything wrong here?

I have a cell (D7) in a spreadsheet, which has either the word "OUT" or "IN"
entered manually.  The two options are then used in a. "IF" statement to
control a numerical value.
My question is: can this cell (D7) be made so that a mouse-click can toggle

A1:A5 lists the number of times a part is used in an assembly
B1:B5 lists the number of each assembly I want to build
B6 = SUMPRODUCT(A1:A5,B1:B5), which successfully gives me the total demand
for the part.