Sort a small number of cells
 

I have an excel spreadsheet with 2 columns per day of the month, one for
check number and one for the amount of the check. Rows 1-5 are frozen because
they contain headings. Rows 6-20 are for Company A, rows 21-35 are for
Company B, rows 36-50 are for Company C, and so-on. What I need to do is put
the checks for one day and for one company in order so I can find them more
easily on a separate list that has check numbers in numerical order.
Essentially, I need to put an area of 2 columns by 15 rows in numberical
order without changing anything else on the spreadsheet.

I have one document that will allow me to do this, and one that will not.
When I try to do this on the second document, it puts the 15 rows in the
correct order but moves every cell in the rows instead of just the ones I
selected.

Any help would be greatly appreciated!

Sort a small number of cells
 

I don't know exactly what you are doing. You say you "select" a range, then
Excel sorts more than that range. What are you selecting and what do you
want sorted and what is being sorted? Also, how are you selecting this
range?
If you want to sort 3 columns and 15 rows, select all 3 columns and all
15 rows. Then do Data - Sort. Excel will sort those 3 columns and 15 rows
and nothing else. Does this help? HTH Otto
"ALF0525" wrote in message
...
I have an excel spreadsheet with 2 columns per day of the month, one for
check number and one for the amount of the check. Rows 1-5 are frozen
because
they contain headings. Rows 6-20 are for Company A, rows 21-35 are for
Company B, rows 36-50 are for Company C, and so-on. What I need to do is
put
the checks for one day and for one company in order so I can find them
more
easily on a separate list that has check numbers in numerical order.
Essentially, I need to put an area of 2 columns by 15 rows in numberical
order without changing anything else on the spreadsheet.

I have one document that will allow me to do this, and one that will not.
When I try to do this on the second document, it puts the 15 rows in the
correct order but moves every cell in the rows instead of just the ones I
selected.

Any help would be greatly appreciated!