I've inherited a spreadsheet and want to add some data validation to
range of cells.  However, when I select cells, the data validation men
item is greyed out.  If i open a new spreadsheet it works fine.  Ca
some tell me if i have to unset something in order for the validatio

how can i key 4:30 and mean 4:30 pm. thanks
Gordon Wrote:

I saved a query in MS-Query and now want to change it, but I cannot un-press
the Auto Query button to allow me to edit it.  How is that done?

I'm using 2002 and would like to do the following:
We have PN: ####### hundreds of times in our spreadsheets
and have been directed to make the PN: ####### line (out
of 6 lines) bold.  Is there a quick search and replace

I have a list of addresses that I would like to seperate by rows,
example:Golden Bay Federal Credit Union
PO Box 127 Bldg 556
Moffet Field, CA

I am trying to count up the number of times a certain value appears in a
column. This value is in a List so I want to reference where it is in the
list within my formula. I've tried the following but its wrong
=COUNTIF(C$7:C$402,A405)

I would to write a formula that calulates its value based on the current
selected cell. As the user selects different cell the spreadsheet should
recalculate.

I am trying to set up a spreadsheet for employees to use to calulat
there time and I do not want to have to use military time for th
finish time.  Please hel
--

Can I restore a deleted excel file?
Where do I find it?

I just deleted an excel file I need.  Can I get it back? Thanks!

In the macro below, I'm attempting to change the value of cell F12 to an
even number. However, when I run this macro, it simply inserts
"=EVEN(RC[-1])" into cell F12.
Before the macro is run, cell F12 may be even or odd. Can someone help me

My first time using Excel - grateful for help.
I have two files of names/addresses, mailing lists.  I need to join
these two files together so I can then sort them and remove duplicate
names.  How do I join/insert/merge two Excel files, please?

I am trying to put together an easy to use spreadsheet where i can enter
start and finish times for employees over the course of a week and get a
total of there hours worked.
any help would be appreciated.

I cannot seem to get trough this one.  I have a workbook with two sheets.  
Information on sheet two comes from sheet one depending on what is in cell on
sheet one.  Does this make any sense?
Sheet 1

Can anyone help?
I have a sheet with the following data:
Item,   Price1,   Price2,   Price3,   Price4,
I want to sort the prices for each item randomly but not sorting the whole