Using Excel 2003/SP2, I have the check box in tools/options/edit cleared for
"move cursor after enter". Normally this is fine, but I made a sheet with a
few protected cells and now it moves to the next unprotected cell, in
whatever direction is greyed out. I don't often protect ...

Let's say I have a list of 20 student numbers, unsorted, in cells A3:A22.
How, if possible, can I set up my worksheet so that it will automatically
take the values in that range of cells, sort them, and display them in cells
C3:C22 in sorted order?

Is there a way (formula or whatever) to have the 12 months instead of typing
them.
I used Jan in cell B2 and Feb in cell C2, selected both cells and then used
the mouse to copy them to the range D2:M2.

In a nutshell:  I am putting together a database.  I created a search
"grid" that allows the user to choose a name from a data validation
list.  After selecting a name, the grid (shows 4 locations across, and
the 12 months down) uses Sumproduct to count the number of units the

When I try to open an Excel file, nothing responds and I end up having to doa
ctrl. alt. delete and get a message 'you chose to close a non responsive
programme'.
It cannot find excel.exe and when I try to re-install or repair Office it

Folks,
I'm really struggling with this one.
I've got 354 rows of data (rows 3:352). In column G there may be a date. In
column M there is a number (1-12) which represents a monthly period, and in

I write down a type, for example "55,000", which is by default a general
type. From the menu Format, Cells, Number  , I try to make it as an
accounting type(in dollars), I press ok and then my type "55,000" disappears
and appears a "#####" instead. What is this and how can I ...

Is it possible to open Excel files in microsoft Works?

Hola a todos ::
estoy trabajando con unas con multitud de comentarios, y quisiera saber de
que forma puedo "jugar" con ellos mediante macros
las dos operaciones que necesito hacer ahora son

Hello I am new to this site and I am hoping someone can help me. I am trying
to put together a pricing calculator so my staff can easily do quotes for our
client, I currently work out everything manually. I need to put three or four
more costs into this calculator and I am ttally ...

I receive 8 reports monthly, 1 for each area, with the all the activity
for that period. I would like to consolidate the data into one total
sheet. I have a master sheet with all the specialties where I would
like to have all the totals show. The activity will be different each

I would like to format a cell so that I can just type in the numbers in a
date and have the cell display the date with the forward slashes added
automaticly!  Example type in only 040906 and have Excel display 04/09/2006
in the cell.

I cannot open an excel file on  the network, an error occur that
"filename.xls cannot be accessed.The file may be read-only,or you may be
trying to access a read-only location.Or, the server the document is stored
on may not be responding"

I am trying to change a number in the left column to the number in the
adjacent column.  My setup looks like this.
            Number to Change    Change to this Number
            182001                                     182000

I am using zz as my variable
what I want to do is
if  zz is between 7 and 10 then print out a range within a sheet
is the print range line correct ????????