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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top