+ Reply to Thread
Results 1 to 2 of 2

2003 help needed, with sorting & locking rows and stuff. Simple for you, hard for me ...

  1. #1
    Registered User
    Join Date
    01-15-2016
    Location
    Brussels, Belgium
    MS-Off Ver
    2003
    Posts
    1

    Question 2003 help needed, with sorting & locking rows and stuff. Simple for you, hard for me ...

    Hi,

    Believe it or not, I'm still using 2003 version.
    In the past, I did know what I did. Sadly after years, I don't
    know even some basics anymore ...

    In Excel 2003, before I've maded a CD list. Like this: ....

    Testing first CD / Albania / 7 minutes
    Testing 4th CD / Bosnia / 2 minutes
    Testing second CD / Israel / 5 minutes
    Testing 15'th CD / Germany / 2 minutes

    I wanna sort the first colom, from testing first till latest CD.
    I know I need to select that colom and sort from a to z.

    The problem is, the rest of the koloms don't move auto also.
    (counties and minutes)

    I believe I've founded in the past, something to stick rows and koloms ??

    So that I sort on: countries, all the rest moves also
    So that I sort on: minutes, all the rest moves also

    I hope you understand ???

    Pls help, refreshing my mind ...

    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: 2003 help needed, with sorting & locking rows and stuff. Simple for you, hard for me .

    You need to select ALL the columns of data first, and then apply the sort on the column you have chosen.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 12-08-2014, 09:05 PM
  2. Rows to columns hard problem, help needed
    By NicholasLag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2014, 09:55 AM
  3. CopyPaste-HARD stuff
    By MotoXcel90 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2014, 10:45 AM
  4. Locking rows together when sorting
    By chris_nyc in forum Excel General
    Replies: 4
    Last Post: 10-26-2012, 05:05 PM
  5. Locking rows for sorting
    By Paddyscott82 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-29-2011, 12:03 PM
  6. Locking rows together when sorting
    By tuganne1 in forum Excel General
    Replies: 3
    Last Post: 05-02-2009, 04:12 PM
  7. sorting and locking rows
    By DanMnz in forum Excel General
    Replies: 5
    Last Post: 07-19-2007, 10:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1