Data | Filter | Autofilter
is probably the fastest way to simply look at rows with specific DEPT#
entries in them. If you've got some special need to do much more than that
with them, then we'd need a more detailed explanation of what you want to do
with this information.

"kang" wrote:

say:
DEPT1 EMP1
DEPT1 EMP2
DEPT1 EMP3
DEPT2 EMP4
DEPT2 EMP5
DEPT3 EMP6
DEPT3 EMP7
....
....
....

if I want to group the rows by dept, do I have to select dept1 and group
them, and select dept2 and group... for every dept?

any better ideas?