if I have a column with data in lower case like Rtp Tlp and I should have
them in CAPs can I change it for teh whole column

I'm creating a family tree using Excel and wuold like to have a washed out
old pic as the background.  In order to do this, I need all the grid lines to
show on top of this picture.
How do I put a picture behind everything including grid lines?

Excel (Office 2000 or Office XP) often gives a calculated cell value that
technically should be zero as a very small number instead, say with absolute
value less than 1e-15.  Can I set a format so calculated values below a
certain size limit will be given as zero?  Writing an IF ...

I have a list of 4000 names. I need to number the rows in Column A, but I
need any dupliate names to have the same number and then have the numbering
continue down the column.
Thanks for your help.

{Excel 2003}
Each Row is revenue by customer
Each column is a month {jan-07, feb-07, mar-07}
We have historical revenue for each month.

I have a Column "A" containing 7 company names.
I have  Column  "C" of 3 words
I need in Column "B" to know the following formula.
Does "A1:A7" contain any of the words in C1:C3, and return the result "Yes"

I am creating a form that will be going to a number of people for a client
and it needs to be as easy as possible for them.
1- I have created drop down boxes, is there any way to keep the arrow
visable at all times.  I received a document with it done, but it is

I have a workbook that requires individuals to login to enter data.  Once
they login, data is entered via a form.  My question is how do I set the form
up so that only the users will see the form and not the manager?  There are 4
worksheets, all visible for the manager only.  The ...

I want to use GETPIVOTDATA to pick from a table in which the first column is
a state designator and is not repeated in every record - is this feasible?
I will use the state designator and a code (from the second column of the
Pivot table) to give me the correct premium rate to be ...

I downloaded the new sr3 from microsoft.  I need to save my excel files as a
wk3 file.  The message above now pops up and I am unable to save the workbook
file as a wk3 file.  Help

Can one do the opposite of Text to column
have data in several different columns and merge them into one with a - btw
the content of the diff. columns?

I have selected a range for conditional formatting.  It works fine.  However,
when I type outside that range, the conditional formatting applies there too.
For instance, if I have set up a range of A1:A10 to highlight in yellow and
I type a number greater than 100, this ...

I would like that when a number is entered in column N the person entering
the column is prompted to enter in format 100,000.00 ( ex 250,225) and then
once the number is entered it is converted in format 250.26 i.e. divided by
1000 and rounded off to two decimal places.

Unable to move between sheets as the sheet tabs and the horizontal scrollbar
have disappeared.  The document is only showing one sheet and this appears
like a window that I can move around within the Excel background.  Usually,
the xls document name appears at the top left of the ...

I set up two custom views in a spreadsheet (excel 2003) which used to work.
Now when I try and apply a view I get a message: "Some view settings could
not be applied". The only option is "OK"