My BIG thanks for helping me with this project...thanks to you it's up and
working...
--
David


"Gord Dibben" wrote:

Select A4:H100 assuming you have that many columns and rows.

InsertNameDefine

Give the range a name like MyRangeOK

Now in the NameBox to left of formula bar select MyRange then DataSort

Uncheck "my range has header row".

Select column A from the dropdown and AscendingOK

The three rows above will be excuded from the sort operation.

You could actually make MyRange dynamic so's new rows are added to the range
as you expand the data.

See Debra's site for help on dynamic ranges.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP

On Thu, 6 Nov 2008 10:35:06 -0800, caseysmydog
wrote:

On my spreadsheet I have 3 rows of headings that are not named...I just typed
across the cells until I had what I needed.
The 4th, and subsequent, rows start with a name in cell A4 which has been
widen to accommodate the entire name. A5 would have a name and so on.
Question: How do I sort by name, A4 etc., without getting the headers
involved?
Do I name the A column and refer sort to that and if so, how do you name
that area?
Thanks