I've got Excell 97. Beginner. Can I make Excel sum up data in a column
without specifying a specific cell to display the result?  So, the result
appears in the cell immediately below the last cell in the column containing
data, whatever the position in the column the last cell ...

I am trying to create a "Work Order" template that would have a rando
unique number in a give cell and each time it is opened and saved i
would keep that number even if opened and revised a second time.
I was given a formula that seemed to work but the numbe would chang

Good day.
I've used the import data wizard in Excel with great success to suck out the
data I need from a named table. Now, I'm trying to repeat the process on the
same sheet, drawing from 8 different sources. (mon-sun+misc) So basically,

I am switching from Quattro Pro to Excel...not too big of a difference but one function I use a
lot in Q.P. is changing formulas into data.  How do I do this???  Thanks!

I have about 180 files that are price pages from a company we sell products
from.  The same cell in every file, Sheet 1 P1 is a factor that is used in
formulas through out the files.
I guess I am wondering if there are 1 of 2 solutions.

I am a longtime user of 123,visacalc, and now excel. I have a proble
that is driving me nuts and I can't seem to figure out how to solve it
I must have hit a keyboard sequence that changed my curser in exce
from an arrow to a plus sign. The function of the plus sign behave

Can anyone help me? I have a directory full of xls files each of whic
is a invoice. Cell A11 contains the clients name and address. Doe
anyone know a way in which I can extract the cell contents for all th
files in the directory?

Can someone please help with the vlookup formula. I have rea
information on this but still do not get the main grasp. Maybe a
example or a breakdown for a new user of this function.
Thank

I have set up an excel spread sheet and have used the data group an
outline function to group rows together.
.However when I choose sheet protection I am unable to use the grou
and outline function.

I don't like to take my hands off the keyboard, even to reach for the
cursor pad.  So I have four macros: Up, Down, Right, and Left assigned
to Ctrl-k, Ctrl-i, Ctrl-l, and Ctrl-j.
I'd like to be able to select cells the same way, the equivalent of

Good morning Ladies and Gentlemen
I have a list as below of components. You will note that  5 are of the same
value and C4 C5 are the same value
A                        B

I'm struggling with a problem and any help would be great!
I have a list of 70 applicants that have made their 1st, 2nd and 3rd choices
for apartment units in a building.  I need to give them their first choice
if available and if not their second choice and so on.  They are sorted ...

Hello friends:
I would like to know if my Excel 2003 File will be opened without problems
in Excel 2000. Must I do some additional step to save it correctly for Excel
2000?

I'm using Excel X for Mac, and I'm trying to split my four-digit dat
into two rows with two digits each:
0001 => 00|01
0101 => 01|01

I have a macro which (among other tasks) saves the existing open file to
"temp.xls". However, I want to avoid the dialogue box which says "File
exists . . . do you want to replace?" Is there a line I can put into my
macro which will save the file to "temp.xls" without asking me ...