defining the header row & "end" of spreadsheet

Margorita

New Member
Joined
Sep 21, 2006
Messages
2
I am working on a list and I want to sort it various ways.

I have names on each of my columns (like account id or date purchased) but have not made them "NAMES" or "LABELS" or anything else.

I have formatted them to be displayed at an angle and in bold text.

Now when I sort, it ALWAYS defaults to no header row.

is there anyway to define what the default is in this box, so that it always thinks there are header rows,

or

is there a way to define the header rows?

Also, when you use CTRL + END is there a way to define what is the last cell in your spreadsheet?

Thanks

Lisa
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
Take this example

IsoTrain 25Aug06
I don’t know whether your dates are parked in separate column and whether they re entered as dates and not as text
Suppose the above date is in B2
Now
=month(B2) will give you 8
You can use this as criteria either for filtering or doing sum if or sumproduct.

In vba you can wrie

If month (some range)=8, then (that cell.entirerow. copy) and another destination cell.

These are only some approach to the subject.
 

Forum statistics

Threads
1,141,022
Messages
5,703,788
Members
421,316
Latest member
Cyril Beki

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
Top