I receive thousands of rows of data from an extract that comes from a
database. The data extract automatically generates page headers that
need to be removed, and I would love to automate this process.
The headers do have a pattern to them, but I'm not clever enough to

I have a main worksheet, columns A to H (8 columns), about 1000 rows and
growing.  I insert rows and change data regularly and I want to update
another worksheet, which has only columns A to C plus E (4 columns, as some
of the other info is not for everybody to see).  Would a ...

I looked, honest.
The HELP was no help, either.
Gosh, things were sure simpler with the earlier versions.
Anyway, how do I go about setting the Print-Area boundaries; the area I

I Forget Password Sheet.How Can I Recavery ?
I Use Excel 2007

I have set up an inventory of the chemicals we keep on an excel
spreadsheet... What I want to be able to do is to double-click on a chemical
(ie double-click in a cell) and be referred to new cell that lists the
synonym of that chemical.

I have a column (M) that used to get its value from an earlier column's (E)
value dvided by 18. The, a further column N) worked out the verage of all
values in that column.
So:

I opened a sheet and i could only see the top left gray litle rectangle. No
row nor colomns are seen. What do I need to do to see the rows and colomns?
Khalil

I keep two cash flows on two worksheets. One shows the monthly figures as
discrete months, and the other shows the cumulative figures. So each month I
have to complete the month's figures in the discrete one and then manually
add the figures to the totals in the cumulative one to ...

Hello all these are 2 formulas that both work however I can't seem to
be able to tell it to ignore blank cells... I appreciate all your
amazing help on these forums...
Here is formula #1...

In excell 2003 is there a way to merge cells so the text spans them
all, but keep the current background of the cells (which are not all
the same color)?

What is the proper syntax to concatnate Countif function
Say you want Colum  A =  to equal either 100 or 200 and colum B should
be a date between Jan 1, 2008 and Dec 1 2008

I am new to using drop down lists.  I have created a spread sheet that I use
for construction disbursing.  I want to have page that lists all of my
vendors (Vendors) and the work they provide.  I named column A which is all
of my vendors names as Vendors.  I went to my payment ...

If I have "100BDDDABAABD" in a cell and I'd like to extract the last
10 characters and put each character into a different cells. Then, the
first rest of characters (first 3 in this case) into another cell.
How do I do that in Excel?

In the same excel file, i have one sheet containing data and one running a
MSQuery to retrive some of the data with a parameter. The problem is that
when only one record should be returned, I have that record and a blank
record. Because I have formulas that are auto-extended, I ...

Hello all...
If I type into my worksheet -120... it shows up as -120
However if I type +120... it shows up as 120.
How can I tell excel to show the plus sign in front of positive