Sort Sheet By Date

[TKC100]

I am sure I must be overlooking something simple but I have exhausted my patience and I am hoping someone can assist me.
I have a simple sheet, Column 1 is date, row 1 for some reason lists the columns by number, I did not create this row, row 2 is my headers (Date, Vendor, Debit, Credit Description and so on until column 17)
When I select column 1, row 2 - 59 and attempt to sort A to Z the header row 2 is moved to row 59 and I was never asked to expand my selection to include all of the columns.
I have never seen Excel do this before. Can someone educate me?

 

[dreid1011]

Are you able to delete the erroneous row 1 with numbers and then sort?

 

[TKC100]

I am not even sure how row 1 got there. It is does not say row 1
Instead there is a unnumbered row listing columns 1 to 17
The numbered rows are 2 to 59
2 is my headers and it is frozen via freeze panes.

 

[Fluff]

I am not even sure how row 1 got there. It is does not say row 1
Instead there is a unnumbered row listing columns 1 to 17

Does this mean that you don have the column headers showing A, B, C etc all the way to XFD?

 

[TKC100]

It has been some time since I was active on this forum and it has changed quite a bit. I prepared a example sheet but I'm not sure how to attach it. I prepared an example sheet but can't see how to attach it.
I have got to attend to another matter right now. Will try to figure out the Mini-sheet later today.
Thanks!

 

[TKC100]

Example.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	Date	Vendor	Debit		Credit	Description	Receipt	Rent	Utilities	Groceries	Insurance	Auto	Fuel	Medical	Household	Clothing	Misc.	Pet	Tax	Cash
3	2/1/2024
4	2/2/2024
5	2/2/2024
6	2/2/2024
7	2/3/2024
8	2/6/2024
9	2/6/2024
10	2/6/2024
11	2/7/2024
12	2/11/2024
13	2/10/2024
14	2/10/2024
15	2/8/2024
16	2/8/2024
17	2/5/2024
18	2/8/2024
19	2/12/2023
20	2/14/2023
21	2/21/2024
22	2/21/2024
23	2/21/2024
24	2/21/2024
25	2/21/2024
26	2/20/2024
27	2/18/2024
28	2/18/2024
29	2/18/2024
30	2/18/2021
31	2/17/2024
32	2/17/2024
33	2/16/2024
34	2/15/2024
35	2/24/2024
36	2/16/2024
37	2/15/2024
38	2/18/2024
39	2/20/2024
40	2/23/2024
41	2/21/2024
42	2/29/2024
43	2/28/2024
44	2/28/2024
45	2/28/2024
46	2/29/2024
47	2/27/2024
48	2/25/2024
49	2/25/2024
50	2/24/2024
51	2/24/2024
52	2/24/2024
53	2/23/2024
54	2/22/2024
55	2/22/2024
56	2/21/2024
57	2/23/2024
58	2/29/2024
59	2/29/2024
Sheet1

 

[TKC100]

I don't know if I am doing this right or not. But it's my first best attempt.

If I go to Page Layout and deselect Headings View the Column 1 to 17 header goes away but then I can't see row number or column letters
With Heading View selected there is no row 1. My header starts on row 2

The superimposed column heading does not show up in the Mini-sheet
On my sheet in place of A,B,C...... there's Column 1,2,3....
There is no row 1

If I go to Page Layout and deselect Headings View the Column 1 to 17 header goes away but then I can't see row number or colums letters
With Heading View selected there is no row 1. My header starts on row 2

 

[Fluff]

It sounds as though you have it set to use R1C1 notation rather than A1 notation.
To change that goto File, Options, Formulas & uncheck the R1C1reference style checkbox.

 

[TKC100]

I had already tried that but thanks for the suggestion.
Can you see how there is no row 1?
My header starts on row 2
When I attempt to sort by column 1, date row 2 (my header which is frozen) will go to the last row on the sheet

 

[Fluff]

Why not just delete the numbers in row 1?