is it possible to use "Chip Pearson's Rowliner" on a protected sheet. I have
had problelms. It works fine on a unprotected sheet, but when it is
protected, it does not work. We really need "rowliner" but it is also very
neccessary to protect the workbook sheet. What do I do? ...

I want to add up numbers in a line automatically for ex.
In column A I have 827 and in column B I have 45, I want column C to have
what A and B columns equal together. How do I do that in excel.

How do I copy page break to multiple sheets.
Thank you.

I cannot change page breaks when in page break view.
I have tried 'Tools, options, edit tab, allow cell drag and drop but this
has made no difference.

In one cell, I reference a cell in the next column to the left and one
row down
e.g., in cell Y182, I have:
if (Z183 = "No content liens","n","y")

I have downloaded my last six months spending from my banks website and
created a spreadsheet which I have reduced to 3 relevant columns - Date
(mm/yy), Category (utilities, food, etc) and Amount.
I want to be able to summarize and chart the data by the total Amount spent

I'm trying to sort a spreadsheet by a column that begins with a date
but has other information in the cell. When I sort by ascending it
begins with the cells that don't have any dates preceding the
alphabetical content then it will start with "4/6/2008 then 4/2/2008

Here are two question that a student recently asked.
They build houses. They only work weekdays, Monday-Friday.
1) Question 1: They want to put in a starting date in one cell and put the
number of days it will take to complete the house in another cell. They want

some help please.
i reached to the following :
=CHOOSE(MATCH("X";F7;0);5)   which means  if cell f7  has  x
give me exactly  5

I am using Office 2007,
OK, I need to plot a boxplot base on a 5 number summary
data.(q1,min,median,max,q3) my problem here is, how do I decrease the gap
width of the Up/down bar? In another words how do i reduce the box width if u

I'm a genealogist building a database using Excel 2007, but I can't sort by
dates in chronological order as Excel does not recognise dates pre-1900.
I want to sort by date format: eg 25 Aug 1834, 8 Jan 1732, 30 Sep 1749 etc.
Is there any way of doing this other than reversing the ...

I have a mini invoicing system and I would like to insert invoice numbers
that would increment automatically.
At the moment I am using this formula:=IF(K10>0,'01'!L7+1,"")
'K10' is the cell I insert the date in so I can see the invoice number only

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.
For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I have the following formula =AND($A$6="w",$F$6>TIME(7,0,0))+$F$6
which is great. If the letter W is added into cell A6 and the time is
greater than 7 hours in cell F6, F6 will be shaded in red. If no W is added
in A6 this rule does not apply.

Why are there Green Button Icons for things like Paste Special Values and
Paste Special Formulas?  Excel2003 had individual icons for those tasks.  The
green buttons are useless since you can't distinguish the functions without
waiting for text to popup when you hover your mouse ...