I have seen a worksheet in which the Office Assistant gives custom
messages about the information to be entered.  How do you customize the
comments of the Office Assistant?

I'm attempting to create a single Pivot Table that automatically
applies a filter, depending on what the user enters into a form.  For
example, salesperson "John" opens the excel file and enters his name
into a pop-up form.  Then a Pivot is displayed with only John's

I'm trying to average a range in another workbook but I want the average
to work when the source workbook is closed.  I also only want to averag
numbers more than zero.
I'm currently using DAVERAGE which returns a #VALUE because of the

I've recently had to replace a few SUMIF formulae with SUMPRODUCT as
they were summing ranges in other workbooks, but, more importantly -
*closed* workbooks.  Consequently the SUMIFs returned #VALUE errors
until the source files were opened.

If possible...
How do I get excel to change the color of a "grid" if I enter say
specfic letter or word in it.
Example.

I hope someone can be of assistance in this problem:
I have an m X n matrix.  I have the mean and standard deviation of this
matrix.  Without writing code, how can I look through the matrix and
pull (and copy to a cell) every value above one standard deviation.

I have Excel 2000, when I open a new workbook my column headers are labeled
A-Z and my rows are labeled A-Z.  How do I get the rows to be labeled 1-?
again?, is this part of the default template, if so can I delete and will
Excel recreate it for me? Lastly, what is the name of ...

Hi,
I have 4 columns of data that are over 1000 rows. I would like to wra
those 4 columns so that I can fit 3 sets of the columns on a printe
page. Is there a way to do this short of copying and pasting?

I have a 3 column list and need to pull the value from column 2
whenever there's a value in column 1 for that row.  I've been using the
following formula to accomplish this:
{=IF(ISERROR(INDEX($A$1:$C$99,SMALL(IF($A$1:$B$99=ControlSheet!$H$6,ROW

I am trying to link several fields in Excel to a Word Doc.  I'm linking the
fields using Ctrl-Paste as Hyperlink.  The linking works fine.  However,
when I try to save the files in different folders or move the files, all the
links are lost.  This makes it very hard to replicate the ...

I am trying to create a stock portfolio data spreadsheet for Excel 2007,
but I am encountering many problems.
Firstly, I am trying to find a formula that will divide the current
value of the stock with the initial price. However, I receive a #Value

I'm working on a spreadsheet created by someone else. The cell lines are
not displayed. All I see is a white background. How do I restore the
cell lines so that I can see them?

It's quite odd.  I can open the same spreadsheet locally and can instantly
edit it, but if I open it over our LAN, it shows the first page but acts
frozen for 30 - 60 seconds before Ican click on any cells and edit them.
I have searched KB articles with no solutions to be found ...

Does anyone know how to add a new paragraph in a cell?
Example:    Book Sale
It needs to look like this:
Book

Hello!  I'm trying to sort a spreadsheet numerically.  The column
I'm using for sorting contains either single numbers, or ranges of
numbers, as in these examples:
614