Hello!!
I need for help please!
When I would like to change the width of a cell or a column I can't
set up a concrete value.

All,
I need help: how do I put 0.1 number in Indent as it starts with 1 and does
not let me input less than 1.
Thanks in advance.

I'm working with payroll data. I have a formula that displays payroll data
that's based on a payroll date. Until the payroll date is reached the cell
reads FALSE. Is there a way to display a 0 instead? This is the formula
=IF(A30>=A36,SUM('3-15'!X38 +'3-15'!AB38 + '3-15'!AF38 + ...

Excel 2002 SP3
Win XP Pro SP2
Hi,
I need to pass a spreadsheet around to others BUT I also need to have a

How can I select all shapes on a sheet other than holding the shift down and
selecting one by one?
Using Excel 2000

Is it possible to fill an excel shape, circle, rectangle, autoshape
etc. with data from a cell or a name.  I mean for it to actualy read
and display the data not just paste in as text.  I cant see anything
so far but maybe that is a "trick"

I used to have Crystal Ball installed as an add-in for school. When the
license ran out, I took it off Excel 07, and uninstalled it from my computer.
Now I am trying to install analysis toolpak (it's on my computer), but when I
click (office button) > (excel options) > (Add-Ins), ...

I have customer numbers listed in column H and customer names listed in
column I.
I would like a formula in cell B6 that returns the corresponding customer
name when a customer number is entered into cell A6.

Environment = Excel 2007, Centrino Dual-core 2.3MHz processor, 2Gb
RAM, WinXP Pro.
I am trying to optimise a fairly large set of workbooks for a client,
some of which have multiple worksheets, and some of those worksheets

I have a worksheet that I am using a VLOOKUP to get amounts for a
calculation. This is partial data, so, I have many #N/A in the column along
with other cells that contain real numbers.
How can I "SUM" this column (basically ignoring the "N/A" until they are

I have a list of names from a website. The html has each person's name as a
mailto hyperlink. When I paste this list into excel the mailto formatted
names remain. I can view the email address in each link but I am looking for
a way to extract the address from the names and put ...

This is something which I'm sure I found the answer to before, but
have now forgotten!
If I have a column of data on worksheet1, and it can cover an unknown
number of rows.  I want to mirror it on worksheet 2. I could just

In Excel 2000, I use to be able to see a data field in the toolbar area. If
I entered something in the current field, it would be their too. I could
also choose to enter data there. I noticed a while ago that it had
disappeared. I have only just tried to restore it but not having ...

I have made changes with my worksheet but now I can not access my drop down
lists any more.  I have cleared them then re-validated them, but nothing is
showing - no arrow, no data.  When checking the valadation, the data is
correct but still nothing.  I can insert drop downs in ...

I tried using the VLOOKUP AND MATCH functions, but they don't work for
the data I have.
I have two worksheets and they don't have unique identifiers. Below is
an illustration of my data.