Excel 2010 sorting


  1. Posts : 140
    Windows 7 Professional 64 Bit
       #1

    Excel 2010 sorting


    Hi is it possible to lock columns and rows together so when i sort a spreadsheet i make sure all the rows and columns are sorted together and i dont leave out somthing

    Regards
      My Computer


  2. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #2

    Yes - highlight all the data by selecting all the columns, or highlighting all the data before sorting.
      My Computer


  3. Posts : 140
    Windows 7 Professional 64 Bit
    Thread Starter
       #3

    Ok thanks thats what i do now but if i am not carefull and i miss something it makes a mess of the spreadsheet, i was woundering if it could be sorted without me having to select the data, say some sort of a macro, but i dont know how to do it.

    Also i dont always want to sort the whole spreadsheet just some of the rows and some of the columns.
      My Computer


  4. Posts : 19,383
    Windows 10 Pro x64 ; Xubuntu x64
       #4

    Mmmm. I'm afraid I cant help you there. The Sort usually requires you to select the cells first. Perhaps some sort of VB script would do the trick....unfortuanetly thats beyond me.

    Let us know if you find a method....

    Good luck,
    Golden
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 22:58.
Find Us