Custom Header Row for Sorting

[network_engineer]

Hello!

Could I request some help on this please?

I wish to sort data; however, the row that I would like to use onwards is row 11 (currently). The other rows have more statistical data; how would I stop Excel from using Row 1 automatically as the header row and using row 11 please?

Thanks a lot.

Kind regards!

 

[Akashwani]

Hi,

If you are using Excel 2007 have you tried converting the range from row11 down to a Table?

Excel Workbook
	A	B	C	D	E	F	G
9	*	other data	*	*	*	*	*
10	other data	*	other data	*	*	*	*
11	Name	Clock Number	Postion	Department	From	To	Duration
12	Bill	111111	Clerk	Wages	02/02/2000	20/03/2004	4 years, 1 months, 18 days
13	Tom	111112	Manager	Production	02/02/1998	20/03/2004	6 years, 1 months, 18 days
14	Bob	111113	General Op	Production	02/02/2004	20/03/2006	2 years, 1 months, 18 days
15	Sue	111114	Auditor	Accounts	02/02/1999	20/03/2001	2 years, 1 months, 18 days
16	Flo	111115	General Op	Production	02/02/2002	20/03/2002	0 years, 1 months, 18 days
17	Mo	111116	Cleaner	Services	02/02/2000	20/03/2001	1 years, 1 months, 18 days
18	Dan	111117	Electrician	Services	02/02/2008	20/03/2009	1 years, 1 months, 18 days
19	Den	111118	Electrician	Production	02/02/2000	20/03/2002	2 years, 1 months, 18 days
20	Jo	111119	Cook	Canteen	02/02/2002	20/03/2004	2 years, 1 months, 18 days
21	Joe	111120	Fitter	Services	02/02/1999	20/03/2000	1 years, 1 months, 18 days
22	Tim	111121	Fitter	Production	02/02/2001	20/03/2002	1 years, 1 months, 18 days
23	Ben	111122	General Op	Production	02/02/2002	20/03/2002	0 years, 1 months, 18 days
Master

The above imagine doesn't show it but all the headings have filters on them.

Just a thought.

Ak