Re: excel mind of it's own

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What you need is a setting cheked in the sort dialog: "My table has headers".
This will automatically be checked if you format the first row differently, like Bold

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<keepout@xxxxxxxxxxxxxxxxx> wrote in message news:8ab3t4drs1n1674vpfblaa63b6cr8s3dch@xxxxxxxxxx
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 missing, 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 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.

.

Relevant Pages

  • Re: Reverse order file dialog box
    ... UserPreferencesMask is another one that uses multiple bits for many settings. ... mainly sort order. ... Ctrl + Close saves folder settings. ...
    (microsoft.public.windowsxp.basics)
  • Re: Black text on black background
    ... select fx>bevel & emboss and adjust the settings to suit. ... You mentioned you wanted "sort of raised and embossed"...,but then said you ... its for the web choose web colours. ...
    (comp.graphics.apps.photoshop)
  • Re: SE W800 Update firmware
    ... As a newbie to reflashing etc, what sort of info regarding settings ...
    (uk.telecom.mobile)
  • Re: tables
    ... bypass excel altogether and have the data within the application ... Just because you were using Excel before, that doesn't mean that the data needs to be in any sort of Excel-like object when it's entirely contained within the application. ... As far as saving goes, you have a variety of options, but one of the simplest is to put the data in your applications settings and use the Properties.Settings.Default class to read and write them. ... The array of doubles won't automatically serialize, so probably the best thing to do there is write some custom code that writes to a StringWriter based on a StringBuilder, and then save the resulting string in the application settings. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Incoming font/formatting messing up
    ... I sort of knew that. ... looked in all the settings I can think of & can't find the answer. ... Outlook 2007 uses Word as its rendering engine and, as such, does not ... Expect rendered HTML to look different in Outlook than in a web browser. ...
    (microsoft.public.outlook)