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 If you are working in Excel 2007 - instead it's a checkbox in the upper-right corner labelled 'My data has headers' Hope it helps you ! - Rodney POWELL [ Microsoft MVP - Excel, 1997-2009 ] www.BeyondTechnology.com 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
