Named Range Header Row in Excel 2007

G

Guest

Lately I've been seeing the row ABOVE my named range as containing the
headers when doing a Data / Sort with the "My data has headers" box
checked.

Does this make sense?

I suspect that I've changed some option somewhere to cause this but I can't
find it now.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

not your typical Pivot Table Named Range question 7
Chart with Named Range error 1
Sumif with named range of nonadjacent cells. 6
Pivot Tables in Excel 2007 vs 2003 1
Formatting As Table with OUT header row formatting 7
Find Specific Rows in Range and Create New Tab 18
Import excel named range into Access error 3011 1
Large Dynamic Named Range Sort Problem 1

Top