Sort Rows Ignoring Headers

[Dick]

I have several pages of data in rows. Each page has the same column
headers for use when printing out just that page. I want to be able
to sort all the rows on all the pages as a single sort without getting
the headers involved. How do I lock out the headers from the sort?

[Peo Sjoblom]

When you do the sort make sure you check "My data range has Header row"
before you sort, that is only necessary when sorting text, if you sort
numbers headers will default to that

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"****" <LeadWinger> wrote in message
news:qc6i02t0vaqg1i580e4f9tgn6f9nor4kpd@4ax.com...
>I have several pages of data in rows. Each page has the same column
> headers for use when printing out just that page. I want to be able
> to sort all the rows on all the pages as a single sort without getting
> the headers involved. How do I lock out the headers from the sort?

[John Crosher]

I assume you mean "worksheets", rather than pages. You cannot sort multiple
worksheets in one sort action, as the sort process requires a column for the
sort criterion. You will need a macro to join all the separate sorts
together. Do the first sort while recording a macro, then copy the sort
process within the macro procedure for each worksheet, modifying each one for
the respective sheet.

Use Peo's advice for ignoring headers.

"****" wrote:

> I have several pages of data in rows. Each page has the same column
> headers for use when printing out just that page. I want to be able
> to sort all the rows on all the pages as a single sort without getting
> the headers involved. How do I lock out the headers from the sort?
>

Hi

If you mean that your single sheet has lots of pages of data, just set the
heading line once at the top. You can then use File/Page Setup/Sheet tab and
set the 'Rows to repeat at top' to $1:$1. When you print any individual
pages, it will still include the first row of headings.

Andy.

"****" <LeadWinger> wrote in message
news:qc6i02t0vaqg1i580e4f9tgn6f9nor4kpd@4ax.com...
>I have several pages of data in rows. Each page has the same column
> headers for use when printing out just that page. I want to be able
> to sort all the rows on all the pages as a single sort without getting
> the headers involved. How do I lock out the headers from the sort?

[Dick]

Thanks Andy. I will try that. I really didn't want to get involved
with macros. It's just a simple data base with no calculations that
several people need to be able to sort as needed.

****

On Sat, 4 Mar 2006 12:10:48 -0000, <Andy> wrote:

>Hi
>
>If you mean that your single sheet has lots of pages of data, just set the
>heading line once at the top. You can then use File/Page Setup/Sheet tab and
>set the 'Rows to repeat at top' to $1:$1. When you print any individual
>pages, it will still include the first row of headings.
>
>Andy.
>
>"****" <LeadWinger> wrote in message
>news:qc6i02t0vaqg1i580e4f9tgn6f9nor4kpd@4ax.com...
>>I have several pages of data in rows. Each page has the same column
>> headers for use when printing out just that page. I want to be able
>> to sort all the rows on all the pages as a single sort without getting
>> the headers involved. How do I lock out the headers from the sort?
>

[Dick]

Andy -

Thanks a lot. That was exactly what I needed, and very simple too!
Although I set the pages to repeat as A1:A4 as there were four rows
that needed to be repeated. I didn't try the $1:$1.

****


On Sat, 04 Mar 2006 07:44:52 -0700, **** <LeadWinger> wrote:

>Thanks Andy. I will try that. I really didn't want to get involved
>with macros. It's just a simple data base with no calculations that
>several people need to be able to sort as needed.
>
>****
>
>On Sat, 4 Mar 2006 12:10:48 -0000, <Andy> wrote:
>
>>Hi
>>
>>If you mean that your single sheet has lots of pages of data, just set the
>>heading line once at the top. You can then use File/Page Setup/Sheet tab and
>>set the 'Rows to repeat at top' to $1:$1. When you print any individual
>>pages, it will still include the first row of headings.
>>
>>Andy.
>>
>>"****" <LeadWinger> wrote in message
>>news:qc6i02t0vaqg1i580e4f9tgn6f9nor4kpd@4ax.com...
>>>I have several pages of data in rows. Each page has the same column
>>> headers for use when printing out just that page. I want to be able
>>> to sort all the rows on all the pages as a single sort without getting
>>> the headers involved. How do I lock out the headers from the sort?
>>