Sort Sheet By Date

T

TKC100

Board Regular
Joined
Nov 16, 2005
Messages
59
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?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
Are you able to delete the erroneous row 1 with numbers and then sort?
 
Upvote 0
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.
 
Upvote 0
TKC100 said:
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
Click to expand...
Does this mean that you don have the column headers showing A, B, C etc all the way to XFD?
 
Upvote 0
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!
 
Upvote 0
Example.xlsx
ABCDEFGHIJKLMNOPQRST
2DateVendorDebitCreditDescriptionReceiptRentUtilitiesGroceriesInsuranceAutoFuelMedicalHouseholdClothingMisc.PetTaxCash
32/1/2024
42/2/2024
52/2/2024
62/2/2024
72/3/2024
82/6/2024
92/6/2024
102/6/2024
112/7/2024
122/11/2024
132/10/2024
142/10/2024
152/8/2024
162/8/2024
172/5/2024
182/8/2024
192/12/2023
202/14/2023
212/21/2024
222/21/2024
232/21/2024
242/21/2024
252/21/2024
262/20/2024
272/18/2024
282/18/2024
292/18/2024
302/18/2021
312/17/2024
322/17/2024
332/16/2024
342/15/2024
352/24/2024
362/16/2024
372/15/2024
382/18/2024
392/20/2024
402/23/2024
412/21/2024
422/29/2024
432/28/2024
442/28/2024
452/28/2024
462/29/2024
472/27/2024
482/25/2024
492/25/2024
502/24/2024
512/24/2024
522/24/2024
532/23/2024
542/22/2024
552/22/2024
562/21/2024
572/23/2024
582/29/2024
592/29/2024
Sheet1
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
Why not just delete the numbers in row 1?
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
Sorting Sheet by date column
Replies
1
Views
376
dermie_72
D
Z
  • Solved
Date and Time Not Sorting
2
Replies
19
Views
317
MARK858
MARK858
G
  • Question Question
Stop sort after data is sorted with button
Replies
6
Views
136
Peter_SSs
Peter_SSs
I
  • Question Question
If date in cell is older than todays date by 1 month Then Font RED
2 3
Replies
23
Views
519
Peter_SSs
Peter_SSs
R
  • Question Question
How do I rank a table, formula or macro please?
Replies
5
Views
123
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,911
Messages
6,175,329
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top