• Lock Rows in Excel

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Lock Rows in Excel

    • This topic has 5 replies, 4 voices, and was last updated 24 years ago.
    Author
    Topic
    WSKel
    AskWoody Lounger
    March 28, 2001 at 7:12 pm #354396

    Okay, I need a refresher, any ideas?

    I want to be able to sort a column without changing the order for the whole set… Help! ouch

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHans Pottel
      AskWoody Lounger
      March 28, 2001 at 7:21 pm #520650

      Isn’t that something for Data >> Sort?

      Reply | Quote
      • WSKel
        AskWoody Lounger
        March 28, 2001 at 8:01 pm #520653

        Yep that does it.. Thanks! (I forgot.. doh)

        Reply | Quote
        • WSDougKlippert
          AskWoody Lounger
          March 28, 2001 at 9:11 pm #520660

          Be sure to select just one cell in the database. If you select the column, for instance, the records will be sorted out of synch

          Reply | Quote
          • WSMichael Evans
            AskWoody Lounger
            March 28, 2001 at 9:53 pm #520670

            If there is data beside the column you select, XL97 warns you there is data next to your selection and it will not be sorted.

            Reply | Quote
            • WSDougKlippert
              AskWoody Lounger
              March 28, 2001 at 10:30 pm #520676

              Right, you’re given the choice to expand your selection or to go with the current selection. I’ve seen too many people choose the later option by error. Hence the warning. bummer

              Reply | Quote
    Viewing 0 reply threads
    Reply To: Lock Rows in Excel

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.