I use excel 2002 at work and its very frustrating for something (stack of
paper, hand, etc.) to hit a key and, if im not paying attention, change my
cell contents, without my knowledge. Is there any way I can have excel prompt
me before changing the cell contents or deleting ...

I am using MS Office Enterprise 2007 (home use program).  I have a brand new
All-In-One Printer. It works just fine except when trying to print an Excel
spread sheet.  I like to print gridlines and have tried to print both with
and without them.  The print is exceptionally slow ...

I got data in column A, B C and D
I need to sort by column A based on the quantity of cells with same content.
I got this:
banana

One tricky question       
I have a two tables - one is a source data and the second one is a new data.       
The two have same column headings.       
The new data table can have new records or same records same as source data,

I have the following formula on one worksheet 240 times. Of course the
formula is a bit different but the length is pretty much the same. Is there
an easier way to speed up the calculating process of this worksheet? Can this
type of formual be put in VB code behind the worksheet ...

Hi, I'm trying to use the "OLE DB Provider for Microsoft Directory Services"
in Excel 2007 but I can't make it work. I go to "Data", "Get External Data",
"From other sources", there I select "From Data Selection Wizard",
"Other/Advanced", "OLE DB Provider for Microsoft Directory ...

I work for an international company and when I download reports to excell or
access the dates and $$ come in European format, How can I reformat to
american?  24/8/2007 to 8/24/2007? and 1.000,00 to 1,000.00. Thanks!

I would like excel to ignore email addresses, and stop launching my email
program when I click on a cell containing an email address. I would like to
apply this setting to everything I do in excel if possible, rather than
applying it to each worksheet or cell.

I would like to set up a conditional format whereby if today's date
minus [date in referenced cell] was greater than a certain number, then
the fill colour of the cell would be changed.
I've tried experimenting with setting this up, but just don't seem to be

I have 8 dates in a Range A2:A9 (A1 is header) like so,,  (4 are unique)
MyDates
12/31/2006
1/25/2007

I want to highlight the cells that do not get a result from the VLOOKUP
function.  I tried setting the conditional format to Cell Value = "N/A" (and
other variations) but with no luck.

I'm new to these parts and I'm hoping someone can help me. I have a
simple email list of 4000 addresses (List A) and some are no good.
I've made a separate list (List B) of those bad email addresses and
want to delete all of them from the initial list (List A). Is there a

I want to number my rows. My table is names, addresses, tel numbers, etc. I
would not want the number to be tied to the row because I will be adding new
rows from time to time and the number field would have to adjust accordingly.
Is this possible in excel 2007. Thanks much.

Using XL 07, want to calculate median.
have worksheet of census data by zipcode that makes displays data within 25
miles of inputted zipcode.  these may range from 20 to nearly 60  zipcodes.  
one field is median hshld income.

I need to sort a column say "c" which contains numerical data. When i press
"a to z sort" button the numerical data is sorted as alphabetical data i.e
it  ignores positive and negative signs and after 10, the value 100 comes
and 20 then -20 then 200 like this. How to sort this data ...