 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Sorting spreadsheet data - curious
I'm using Excel 2002 and have a workbook with 3 identical worksheets in it. I have frozen the top 5 rows, using them for headers. On one sheet, when I want to sort the data starting in cell A6, I go to that cell and then to Data & Sort. The window that opens, opens properly - with the "No header row" button selected. The window that opens for the other sheets has the "Header row" button selected and the data doesn't sort the first row. Why the discrepancy? And how do I get the "No header row" button to be the default? Can you post a sample of the top 6 rows? Thx, JP > I'm using Excel 2002 and have a workbook with 3 identical worksheets in it. > I have frozen the top 5 rows, using them for headers. [quoted text clipped - 5 lines] > Why the discrepancy? And how do I get the "No header row" button to be the > default? Hey, I got your sample by email. If you want to select a single cell in a range and have Excel "know" how to sort it, it has to be surrounded by whitespace -- at least one blank row/column around the data. (Obviously if your header is in row 1, this doesn't apply.) Plus, the header row has to be immediately above the data, completely filled in (i.e. no blank cells in the header row) and it must be offset somehow by using Bold, Italics, Fill coloring, etc, so Excel can automatically identify it as the header row. And It can't be two rows. Your data doesn't have a header row immediately above the data, and there is no blank row above the header that is there, and the header spans two rows, so Excel is confused. Even if you highlighted the data you want to sort, Excel wouldn't know what to do because there is a blank row between the data and the headers. HTH, JP > I'm using Excel 2002 and have a workbook with 3 identical worksheets in it. > I have frozen the top 5 rows, using them for headers. [quoted text clipped - 5 lines] > Why the discrepancy? And how do I get the "No header row" button to be the > default?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.