+ Reply to Thread
Results 1 to 2 of 2

How do I lock all cells in a given row together to one another?

  1. #1
    Michael Goldman
    Guest

    How do I lock all cells in a given row together to one another?

    I have created a spreadsheet of 80 rows of business contacts with 7
    columns-name, address etc. I want to to be able to sort all that informatioin
    by columns - i.e. postcode, name-alphabetically etc - making sure that the
    whole of the row stays together, regardless of which column I hjave
    designated for sortinr. E.G. At the momenet, if I sort by postcode, the
    postcode column re-appears in numerical order, but the names, addresses,
    phone numbers columns in each row, all stay where they are and so the
    information is invalid. What I want is that when I sort by postcode, all the
    information stays together with all of its parts (columns).
    Can anyone help?

  2. #2
    Forum Contributor
    Join Date
    08-07-2004
    Location
    Ohio, USA
    Posts
    114
    When you do your sort, you must select the whole spreadsheet then do your sort,that way all of the data stays together as in the original list.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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