Cell grouping

[jackel]

Hello,

This is the problem. I have 5 columns that are in this order, Date
Req.#, Requestor, Dept. and notes. I need to know how to arrange th
entire row where the departments are grouped together with th
corresponding information. The dates are not important as this repor
is quarterly; I know how to sort a column by itself but not the entir
page.

Thanks

 

[jackel]

I should add that usually Excel is smart enough to know that when you
grab
one column of information to sort, and it is contiguous with other
columns
with data in them, to grab them all and use the one you started with as
the
key. But the way I laid out above is the 'sure and certain' way.

:
-
Select all of the cells in all columns/rows that is to be sorted.
Then, from
the menu bar, use Data | Sort a 'wizard' will pop up and ask you
which
columns to use as the sort key(s). This will keep all of the data
together
as it is sorted by your departments.

:
-

Hello,

This is the problem. I have 5 columns that are in this order, Date,
Req.#, Requestor, Dept. and notes. I need to know how to arrange the
entire row where the departments are grouped together with the
corresponding information. The dates are not important as this
report
is quarterly; I know how to sort a column by itself but not the
entire
page.

Thanks,

That worked perfect, Thanks for the info!