Stupid question really, but my spreadsheets are just displaying the formulae
in the cells. How do I change them to just display values?
It's so easy I can't see it!
Regards

I m new to macro section. . If i m selecting a2 cell then the value will be
captured in
a3 cell r anyother cell i want. I want to know the function. plz guide me.

I am new to excel, please excuse my question.
Is it possible to build my own form in excel with feilds, buttons etc of my
own choice.
Could someone help on where to start please.

Using XP Pro and Excel 2002/3
I have been asked to provide an Excel spreadsheet
that people can use as a purchase request form.
Some of the fields will contain data that is already

I have a rather large spreadsheet of  Names, Addresses etc. and I know
there are many duplicates. I would like to know how I can find and highlight
the duplicates in a column. I don't want to remove them, only highlight
them. if the duplicates could be highlighted in a color that ...

I was wondering if there is a way to link columns, so once the page break is
reached that Excel will automatically continue a list in a designated column
to the right?
I am trying to create a multi-paged checklist of DVD titles. The sheet is

How do I protect my Excel worksheet from:
- cell objects being dragged and dropped
- cell objects being copied / cut and pasted from somewhere else
The worksheet is intended to be used as a fill-in form with all possible

Need to know if the following is possible?
I have a worksheet with several columns. One of those columns has some
duplicate entries. What I need a formula to do is locate all the
duplicates in this column. Then, based upon the values found in the

I have attached an excel sheet
I have some percentages in Tab 2 which have to be input in sheet 1
corresponding to the number of days ...
It would be great if someone could help me with the formulas

I am trying to use the VLOOKUP formula to automatically select the
corresponding region when a state is selected.  I have a State drop
down in col D.  And in col E I have the formula
=VLOOKUP(D2,RegionMap,2,false).  In the formula editor it shows the

I would like to create a macro which will automatically close the
excel 10 minutes after it is opened.  I've seen posts containing code
that will close a file, but I don't see any code that does it on a
timed basis.

I'm sure someone has done this with Excel before but I can't find anything
on it.  I have a wooksheet that has the powerball numbers from 1992 to
present, each number has it's own column.
I want to find a formula of some kind that will  tell me what number comes

We're exporting data from a 3rd party application into Excel 2002.  When we
used to do this, Excel would open all of the workbooks in the same
"instance" of Excel so we could move the different worksheets between the
different workbooks.  Now, when we export data, it opens a new ...

Is it possible to count and report the greater streak in a set of streaks?
e.g.
A1 1
A2 1

Is there anyway I can find my password on a
spreadsheet
I developed for the family finances.  I'm getting
old and I