Sorry for the newb question.  but is there a way to have on column the
alphebetised version of another column?  thanks in advance

How can one determine if a cells contais a value or a formula? I'm trying to
use Conditional Formatting to color code the cells based on their content
(formula or value).
Does anyone know?

hey there
I was wondering how to make a list of  col/row scrollable (either horizontal
or vertical) while leaving reast of cells still ?
I have seen it done but it is very confusing ... ?

From time to time I have an Input Box pop up that I did not request.
When this happens, XL locks up and I have to reboot.
Any help will be greatly appreiated.
The box looks like this:

looking for outlook forum or answer
--
hokiegu
-----------------------------------------------------------------------

I'm attempting to create a speadsheet where if a certain value is entered in
a cell, then it applies a cell format to the entire row.  ie.  if you enter
'y' in a cell, then the entire row is coloured yellow or if you enter 'n'
it's green....

i have a countif function
COUNTIF(Locking!I16:I40,"f")
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")

Howdy,
Is it possible to create a list in one workbook and then use anothe
workbook with a combo box to reference it? I know how to reference
single cell, but for some reason, when i try to do the same for a comb

I am very new to excel and could use some help trying to do a formula. On my
worksheet Col B(Hrs Worked Today). Col C(Total hrs worked last 7 days). Col
D(would be 70 hrs minus Col C). Col E(Total hrs worked last 8 days).  I know
the basic formulas to complete the above steps.    ...

I had this idea of creating a master template linked to all my other
templates. Add the address to one and all of them would have the same
address for example
I have created the master template. When I update one template all the

I am having difficulty creating a template and then importing information
from access.
I want to create a standard form (template) that I can import information
from my access database into; email for that person to input info into

Hi, I would like to know if there is a way to format the returned data
from a specific section of a formula.  What I would like to do is
concatenate a date with other data in my spreadsheet.  However, when I
try and do this - CONCATENATE (C2,C3) where C2 is the date, C2 is

I am using Excel 2K SP3 with Win XP pro SP2.
I noticed that the shape of the cursor does not change when I move it over a
command button. This only occurs on the second monitor, on the primary one
everything is ok. Any clues or solutions to this problem? Does anybody know

i have a formula i use in a spreadsheet...
= IF(YEAR(O$1)-YEAR(E3)=105,,YEAR(O$1)-YEAR(E3))
I use it to caculate ages where the current date is in cell O1 and the
Person's birthday is shown in cell E3.

I'm familiar with VBA, but I have never written VBA in Excel.
I have a worksheet that contains personal data on employees.  Some
fields have codes that I need to find the sum of, for example for the
field ECode (column C) I need to count how many are "0", "1", "2", etc.