Using Excel 2000, my columns are arranged by number and not letters, so that
if I'm trying to create a formula to add cells A5 and B6, I get a #NAME ?
error because it does not see a cell A5 or B6, it sees R5C1/R6C2.  Some way
to change this would be greatly appreciated.

I bought a new Dell PC and was assured I would get Word and Excel on it.
Word is there, but all I can find for a spreadsheet is "Micorsoft Works
Spreadsheet."  Is this a new name for Excel?  If not, is it compatible with
Excel?  Why do they do stuff like this?????

I have an Excel spreadsheet that, when opened, executes some SQL queries
against a SQL Server 2000 DB.  This function works correctly.  This
spreadsheet is part of an automated process.  This process starts Excel up
in the background, the data is pulled since the spreadsheet is ...

I want to create an inventory spreadsheet - I'm a new user.
I want a column for the item, a column for the price of the item, a column
for the quantity and a column for the total - ( price x quantity)
Can you give me a very easy way to do this in laymans language?

I want to use keyboad to access the formula bar for enter date instead of
using mouse to get there.

I typicall have 500 rows of data in my columns.  I typically need to
manipulate the data in a quick fashion.  Moreover, I must copy/paste
the data from columns A to Z, for example.
Here is my issue:  I have data in column A1:a500, and I need to move

Is this possible?
Say I have a worksheet and I have the date in one cell.  With that, would I
be able in another cell, have some type of code that says if cell A1 is this
date, to reference the Windows calender or another function, then place the

Im trying to make invoices but I dont know how to make it Automatically
increment the invoice number by one in microsoft excell, Can I save all the
invoices? and when I need them can I just look it up  by the number? can some
one HELP ME im New on computers but if some one can help ...

Can you freeze more than one pane on 1 worksheet (I.e. freeze a column and a
role similtaneously)?

    £ 10.21
    £ 62.09
     This Quarter
    £ 72.31

I AM USING EXCEL 2000.  I AM USING A INVOICE TEMPLATE THAT I OPEN AND SAVE EACH TIME I WANT TO USE IT.  I WANT TO KNOW IF ANYONE CAN HELP ME DO A FORMULA OR SOMETHING THAT WAY WHEN I OPEN MY INVOICE A DIFFERENT INVOICE NUMBER WILL AUTOMATICALLY BE INSERTED WITHOUT HAVING TO DO IT ...

I've turned on filtering and I need to turn on the total
row that sums the filtered data.  For some reason the
option is greyed out.  I've used this before when
importing XML data, but never on just a regular

How can I move an Excel spreadsheet onto my second monitor.  Word and
Internet provide no problems, I just click & drag.

Is there a way to split a sheet, top and bottom, and then to freeze rows
within either or both the top and bottom?  When I split the screen, then
highlight the rows in the top pane that I want to freeze, then hit
freeze, the split becomes the freeze point.  That's not what I want.

I have a financial model I am working on that has about 50 worksheets. When I
added the most recent worksheets, it stopped calculating, or sometimes only
partially calculating results. The same problem happens whether calculation
is set to manual or automatic.