Select the entire range (rows and columns) before you sort.
--
David Biddulph

"Akber Khan, Karachi, Pakistan"
m wrote in message
...
Working on a excel sheet maintaining huge data and need to sort it date
wise,
amount wise (range 1 to 10000, 10001 to 20000).

The problem is that we have data set of different clients, this data set
of
each client spread over 9 columb and 7 rows and i need to sort it in a
group.

How do i do this?
Data set should'nt be destroy?



for example
Columbs a

Name of Client nature of business funded non funded trade
business date of approval limit expiry date fresh/renewal
remarks.

rows a
DM
MMF
IERF
BD/RISK LINE
PAD
OTHERS
SUBTOTAL