What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.

I have to calculate commission on sales tax collected based on the following criteria:
1) If sales tax collected is $11.00 or less, then the commission = to the sales tax collected
2) If sales tax collected is $11.01 - $333.33, then the commission= $11.00
3) If sales tax collected ...

You all know Ctrl+End combo, in Word it goes to the end of document.
Now I want the same function in Excel, but it doesn't work.
Any ideas how to make it work?!

In Excel, how do I prevent a row from moving, like a subheader that I want to
stay always visible at the top of my document?

I have a simple spreadsheet which has many rows, most of which are
outside the visible area on my screen. The top row (number 1) has my
column headings, trouble is as soon as you scroll down the headers
disappear off the top of the screen. Is there any way to lock them, so

I need to do a formula that covers the next conditions:
Max= 5000
Total= 5700
Min = ???

Where are the formula icons in Excel 2007, i.e., the plus, minus, etc..  I
had them on my 2000 toolbar for quick access.

If I have 0:49 minutes in a cell, the number of hours John worked,
and adjacent is $158, the amount John sold; how would I construct a
formula to find out how much John would have sold on an hourly basis?

how can I draw a separater line between the main document and the heade
or/and footer?

Using Excel 2003, what is the formula I would use to accomodate the
automatic calculation of multiple percents within the same worksheet?
For example, if I needed to know what both 6% and also 9% as below?
                            Subtotal   % of Subtotal     Total added to %

How to multiply entire colume with constant:
For example I have colume A
21
26

I have a sheet with approx 50 formulas that links to other workbooks and
worksheets. Does anyone know how to round the entire sheet without adding the
round function to every cell?

I am trying to create a validation list using a name range. The idea
is to only allow each of the values in the range to only be chosen
once. For example this validation would be applied to cells A1:A10.
There would be 10 values in the named range, and each time one of the

How does one freeze two rows I.E. a1 and a23?

Could you kindly assist me with a formula that generate 6 numbers between 1
and 49, without repeating any of the integers.
Thanks!