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
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,984
Messages
5,545,345
Members
410,678
Latest member
glasi
Top