On Tue, 31 Mar 2009 12:32:34 -0700 (PDT), you wrote: > > >Hello Friend -- > >If I'm understanding that you do not want to sort the header (Row 1), > >... just when you call the Sort dialog in Excel 2003, ensure the >optionbutton control near the bottom labeled 'Header Row' is selected >Hope it helps you !
Not so far. I'm using excel 2003 SP3. Hmm sort dialog ? I just use a sort button on the toolbar.. Aha, found the button, BUT now I can't keep the thing turned on. I toggle it for a header row, and hit ok, come back, and it's sprung back to no header. I finally found the actual help. One whole sentence, but it doesn't say how to tell things there's a PERMANENT header. >To exclude the first row of data from the sort, because it is a column header, >on the Data menu, click Data, and then under My data range has, click Header >row. > > >On Mar 31, 9:46 am, cbminfo <cbmi...@bellsouth.net> wrote: >> There's been no problem for years, it did have this problem once >> before. But I didn't write the fix down, or lost the fix. This just >> happened the other day. >> >> I suspect it may be onecare related.. >> onecare is changing all my office security settings to high. And I >> can't stop >> it from doing it. So it's probably the source of this problem. And I'd >> need a >> way to make it permanent that onecare's security changing would have >> no >> effect.. >> >> I have a shopping list.. >> left 1st column A1 is text items to shop for [top label is items] >> Top row is labels of how to operate on the different items, cost, >> store aisle, >> how many needed, how many on hand etc.. with a total cost at >> the very bottom row 61 on down. >> >> To prevent the cost items from getting sorted I gave those items a >> prefix of >> [Z] to keep them locked at the bottom of the sheet. >> >> I've had this set to NOT sort row 1 before, at least a year. This >> problem has >> occurred before. But I can't remember how I fixed it. >> >> I put the cursor on B2 and hit freeze. that worked for scrolling down >> and left >> keeping items in place, and scrolling down, it kept row 1 in view. >> >> I also tried split, but that's most definitely not what I've been >> using for years. >> >> I've locked with freeze the top row, and left column. Trouble is when >> I sort >> the 1st column [items], it also sorts row 1.. >> >> Would be nice to know exactly what changed my settings, and what I >> need to set >> to get the sheet back to it's previous state with row 1, column 1 >> locked, but >> separate to allow sorting the items alphabetically. > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
