Hello
I wonder if anyone can help me with this problem please.
I have and excel file that is used to monitor the progress of some 200
products, when they come into the shop for servicing and repair.

I want to insert a new information between two rows and only the first 5
cells. How can I do that.
DianeH

I have used spreadsheets in the past that have a range of rows that can
collapse or expand in order to view more details.  They had a "+" and "-"
indicator by the row number that you could click on to drill down.  Similar
to how this chat room works when you follow a string of ...

In an Excel workbook the first page includes info from 20 counties. The other
pages in the workbook contain info from each of the individual counties. When
info is entered into any of the individual counties I would like for the info
to be automatically updated in the worksheet ...

I have an address book that I can view on an Excel Viewer that I recently
downloaded from Microsoft.  I would like to import that data into my
wordperfect address book (CorelCENTRAL9).  when I go to map out the fields in
my setup wizard, there are no catagories to select on the ...

I am trying to enter a particular number of 16 digit length (Example:
8312938507652481). This number is being taken as 8312938507652480 in the
excel.
My question is ... is there any limitation in Excel on the number of digits

I'm under deadline and need some help!  My spreadsheet is:
Column A = Date
Column B = Month # (such as 1 for January)
Column E = Expense $ Amount

I need a better formula that will return a column header value if a cell in a
row contains a value greater than 0.  I have over 1000 rows of data. Every
row where value>0 needs to reference the text value in the corresponding
column header.  I know I could replicate the same ...

Is there a way to center vertical text across rows?  If you're familiar with
using "centering text across selection" this is the same type of thing I want
to do but I would like the text to be vertical across multiple rows.
    A     B

I'm sure I have done this in the past but can't remember how.
I am setting up a worksheet to record monthly payments.
I want a running total of these payments and a decreasing running total of
the initial lump sum.

I would like to find the intersection of two variable data points in an
array.  So in the chart below I would like to have a seperate cell (call it
H1) dictate what year in column A to look for and then another cell (call it
H2) dictate what word to look for in Row 1 and then ...

In cell R1, I have the full file address C:\Documents and
Settings\user\Desktop\test.xls
What's the formula to trim it to show just "test.xls"?
I found this formula but it's written for Last Name, First Name MI (and

It's for my project.  I need the formulas in order to input the data.  Please
help!

I am trying to create a lookup table to determine the fiscal period of a
transaction. For example,a transaction dated Feb. 21, 2006 would be in period
14 in a table that started with Jan 2005. The file I am working with is
fairly substantial with numerous transactions every month ...

It's for my project.  I need the formulas to input the data.  Please help!!!