Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb

I'm doubtful that the group is unbiased, but I will ask anyhow :o).  If
one intends to plot lots of data, primarily XY line and scatter plots,
and mass produce them (in many cases I will be doing 88 graphs at a
time - 1 for each of 88 counties), will Exel be the best bet, or is

I heard that sumproduct is very useful. Can I know the functions of it.
Thank you

I have an application to run Excel at the background and close Exce
session after it exits. However, when application is running, Excel i
popped up on the screen and easier for user to interfere the process s
it is prone to user error.

Hi, I have a problem sometimes with the paste special options when goin
from one excel workbook to another.  For example, sometimes when I cop
data from one workbook and then paste special into another, I get th
options that include: All, formulas, values, formats, has the option t

Hi, I am just wonder how to sort the colum with all the fraction on top
or bottom ...ie..
54.375
377

I use an Excel 2003 worksheet for storing the results of my medical lab
results.
One of the columns is labled "Component" and contains the names of the
tests.

hello peeps i'm trying to calculate the number of months from a list of
increasing dates,
b3= 21-Jan-06
b4= 03-Feb-06

My workbook contains about 50 worksheets. I want to allow the user to
select which worksheet they want to look at from the first worksheet in
the file. However, I really don't want to create 50 seperate hyperlinks
by hand! Is there any way to automate this process?

I have just changed jobs and am now working on XP instead of office
2000.  I used to be able to write a formula such as:
=SUMIF(A2:A10,<D2,B2:B10)
I can't seem to be able to reference a cell for a criterion when the

Errors are given in sheet numbers but the sheets have names not numbers.
How do you "go to" a sheet number? I have about 200 in a workbook.
Thanks
John

My daughter was poking around in Excel, "working" through John
Walkenbach's "Excel Bible", including all the little fun stuff (like
rewriting my menu names backwards!).  Now when I type in a cell and
press "Enter", it doesn't drop down to the next cell.  She doesn't

Can someone help me shorten this formula? I'm not sure if the
mathamatics can be shortened by altering the formula or using a
different formula to figure out the problem, but the path name makes it
exceed the max amount of charachters. Changing the linking files path

I'm working in version 2002.  For whatever reason, in this particular file,
merge is greyed out.  Does anyone know how to enable it.
I have some text that I want to merge over a few cells so that I can print
this puppy on one page.

I want to use a multi-range selection as arguments for known_x and known_y
in the SLOPE() function.  If i am on, say, the known_y argument, and select
a range, and then press CTL and select another non-contiguous range, Excel
simply produced two ranges separated by commas, and ...