software

Hello,

I would like to preserve 2 rows for headers (don't want to merge cells,
or use alt-enter to put text on two lines). How do I sort and preserve
these 2 (or more) row headers?

Thank you,
Kathquot;Kathquot; wrote:
gt; I would like to preserve 2 rows for headers (don't want to merge cells,
gt; or use alt-enter to put text on two lines). How do I sort and preserve
gt; these 2 (or more) row headers?

Try selecting only the data rows (below the headers)
then Data gt; Sort gt; Check quot;No header rowquot;
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Hi Max,

Thank you very much for the reply. It's just that I have a lot of data
rows and was trying to avoid the cumbersome task of selecting them all
each time I want to sort.

Thank you,
Kathquot;Kathquot; wrote:
gt; Thank you very much for the reply.
gt; It's just that I have a lot of data rows and
gt; was trying to avoid the cumbersome task of selecting them all
gt; each time I want to sort.

Perhaps try naming the data-range,
then to select it thereafter,
just click the name from the namebox ?

Assuming data range is within A3:K100

Select A3:K100, click inside the namebox*
and key-in: MyData
Press Enter
*box with the droplist just to the left of the formula bar

Then, whenever you need to select the range for sorting,
just click on the namebox droplist and select MyData
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Thank you very much Max.
That works!!!

KathYou're welcome, Kath !
Glad it worked for you.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Kathquot; gt; wrote in message ups.com...
gt; Thank you very much Max.
gt; That works!!!
gt;
gt; Kath
gt;