newbie asking for help

[faxman]

1.how do i exchange the position of any two rows[the whole horizonta
row]
{i know i can insert a new row to the destination row then cut an
paste the other ,im asking if theres any built-in function or whateve
can do the thing in a simpilier way}
2.how do i sort rows by how many filled cells they have?
thx alo

 

[Dave Peterson]

#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.

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