I have a spreadsheet and I have highlighted every other row.  When I delete
or add a row, the highlighting sequence becomes messed up.  I then have to go
back and manually highlight every other row.  Is there a way to format the
spreadsheet so that when I add or delete a row, the ...

Let's say I format cell A1 to be used as DATE and cell A2 will be an entry of
specific # of days for expiration then what formula do I place in cell A3 for
expiration day to appear?

How to separate numbers from a alphanumeri cell.
For Eg: If a cell contains data as 1. Apple25orange50
The result should come as 25&50.
Eg: 2 . sdfldsj2535hlkfd2548dsfs36  - result should be as 2535&2548&36

I am trying to create a formula that looks to another cell with a file name
in and return the result.  Example:
=vlookup(A1,+Sheet1!B6,4,false)
Where Sheet1!B6 contains the file path:  

I am trying to add a trend line but when I get the droop down box the "Add
Trendline" is not highlighted.  This is true whether I use the dropo down on
the chart itself or use the drop down under "chart"

I want ageneral description of validation and the criteria for validation.
I am using office 2003 professional
The result i want should be inthe form of precise definition type.

I want to the cell which contains the maximum value in the row to display a  
colour.And then apply it to the other rows. This will help to identify the
maximum values in each row of data.

Is it possible to sort excel worksheet alphabetic whit one click   ;-)

When I load a previously constructed workbook, I can only access the first
page of the workbook.  I have no tabs at the bottom to maneuver to other
sheets.  How do I get them back?

Greetings all,
Maybe you've seen this one before.  I'm exporting numbers from a database.  
They always export as text.  One report I recently worked on had minus
symbols after the number and I need to remove the false symbols.  Not all

I have a file that has three External Database Queries.  I am trying to
change the Database Path, but the Script Editor is Grayed out.  Any idea why
it is grayed out?

I'm trying to build a formula to calculate the number of working days /
hours between 2 specified dates. This will be used in multiple workbooks, by
various users, who may not have the ability to run code or install the
Analysis toolpak.

Hi My Name is Lloyd
I have a excel sheet headings
Archive
Subject / Title

I have been trying to do the following and cant get it right:
in a (validation) list H5 through h168, i have 6 different names, in a J5
through j168 , i want the cell in j5 to turn the color of the text, ie: h5
has Figdore, in J5 I want the name Blue to come up and make that cell ...

i have a Udf using vsto se for excel .
suppose i have four parameter for the UDFs.
i would like to create new tool tip for the udf.
Is there any way to to have tool tip for the UDF .