Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
How do I lock all cells in Excel except 2 which I need unlocked? | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |