Generally, how can we apply an if condition in a column?. For example let
say that I have a column D1:D1000. How can I say in D1001, if all cells
include numbers multiply them (D1*D2*….D1000), else if one cell include text
or blank then don’t print anything in D1001.

How can I increase the display size of the list on the Data Validation.
When I click the Thingy on the right, the names are small and hard to read
on the screen.

HI,  I am using the new 2007 Beta 2 from Microsoft Excel, the problem I
am having is that the Hyperlinks I used under 2003 were instant when
you clicked on them,  Using the same files in 2007 I have to hold down
the Mouse button for a few seconds in order to activate the link

I have exported from an Order Entry program to comma delimited text file
customer purchases. The file has more entries than Excel can handle on one
worksheet. So, I imported the file data into Access (107,000+entries). I
then used Excel's "Query Database" feature to import ...

I have a column with formulas, and when there is no data to calculate I get
a #VALUE! I would like to hide #VALUE!
Can anyone point me in the right direction?
Thanks

Help!  I am a novice trying to modify a worksheet that someone else
created.  I am baffled by something that I can only describe as a
"floating" cell.  Essentially, it is a cell that has several different
assigned values that change when it is clicked.  For instance, "1"

Group,
I'm sure it must be, but is it possible to use some function which
returns not the contents of the specified cells, but the cells
themselves, as a reference or input to another function?  The reason I

I dim Warning(100) as string
Then I do the following:
Warning(1) = Cells(1, 3) + " " + Cells(3, 3) + " " + "Assessments" + "=
" + Cells(2, 13) + "," + Cells(2, 16)

I have got this macro to run when opening.  All works, but when I password
protect the sheet,  and then close and open i get a run error.
I am not fluent with VBA and get by by recording and pasting other work off
the treads

I am trying to import data from MS Access but it comes as rows i
excel.
Is it possible to while we importing the database into the excel
we change the rows to columns and data still get synce with databas

I have two conditions
1. m2>0
2. =M2-P2<3
It only pays attention to the 2nd condition. As if its and "or" rather

I've spent a long time making a new spread sheet in a new workbook and just
deleated it. Is ther any way to recover my work or must I start over?

Is there a way to use validation over multiple sheets? When I select
several sheets in a workbook validation isn't offered under Data. I was
hoping it would work like formatting over multiple sheets.
John

I already do this using a macro but thought it might be possible with
just a cell function.
Column B has either 1,2,3, or 4 in it. These are service codes. Column C
has hours in it. I want total hours per service in another place on the

I have a Task Account
I use lookup feature with a category list on a separate sheet. OK, so
far.
Right of the category drop down list I have drop down list to choose