#1. I would do what you suggest, but another way would be to select one of the
rows
shiftclick on its border
drag to its new position.
then do the same with the second row.

#2. Insert a new column A
put this formula in A1:
=counta(b1:iv1)
and drag down
select the range to sort and use column A as the primary key.

faxman wrote:
>
> 1.how do i exchange the position of any two rows[the whole horizontal
> row]
> {i know i can insert a new row to the destination row then cut and
> paste the other ,im asking if theres any built-in function or whatever
> can do the thing in a simpilier way}
> 2.how do i sort rows by how many filled cells they have?
> thx alot
>
> --
> faxman
> ------------------------------------------------------------------------
> faxman's Profile: http://www.excelforum.com/member.php...o&userid=37541
> View this thread: http://www.excelforum.com/showthread...hreadid=571797

--

Dave Peterson