Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
I'm Creating a directory based on new clientele and i want it alphabetical.
now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
Simply select the *entire* datalist before you sort.
I suggest to *never* use the sort icons on the toolbar. In fact, I've removed them from the machines of all my users. XL is right most of the time ... BUT NOT all of the time. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "king_reggie" wrote in message ... I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
It didn't happen. the text in column B stays put and only Colum A sorts
"RagDyeR" wrote: Simply select the *entire* datalist before you sort. I suggest to *never* use the sort icons on the toolbar. In fact, I've removed them from the machines of all my users. XL is right most of the time ... BUT NOT all of the time. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "king_reggie" wrote in message ... I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
select the entire worksheet by "ctrl+A".
select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
That didnt work either...after i highlight the worksheet i go into Data but
the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
Click the letter A above your column of names.
Hold down the shift key and click the header letter of the last column that you wish to sort. Data Sort ...... as previously described. George Gee "king_reggie" wrote in message ... That didnt work either...after i highlight the worksheet i go into Data but the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
it still won't let me select sort. do you think that my program is faulty?
"George Gee" wrote: Click the letter A above your column of names. Hold down the shift key and click the header letter of the last column that you wish to sort. Data Sort ...... as previously described. George Gee "king_reggie" wrote in message ... That didnt work either...after i highlight the worksheet i go into Data but the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
I don't think your program is faulty.
I think that your sheet is "Protected". <Tools <Protection <Unprotect Sheet You may need a password! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "king_reggie" wrote in message ... it still won't let me select sort. do you think that my program is faulty? "George Gee" wrote: Click the letter A above your column of names. Hold down the shift key and click the header letter of the last column that you wish to sort. Data Sort ...... as previously described. George Gee "king_reggie" wrote in message ... That didnt work either...after i highlight the worksheet i go into Data but the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
Faulty, no, probably not!
Is the worksheet protected .... Tools Protection? George Gee "king_reggie" wrote in message ... it still won't let me select sort. do you think that my program is faulty? "George Gee" wrote: Click the letter A above your column of names. Hold down the shift key and click the header letter of the last column that you wish to sort. Data Sort ...... as previously described. George Gee "king_reggie" wrote in message ... That didnt work either...after i highlight the worksheet i go into Data but the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
it's not protected.
"George Gee" wrote: Faulty, no, probably not! Is the worksheet protected .... Tools Protection? George Gee "king_reggie" wrote in message ... it still won't let me select sort. do you think that my program is faulty? "George Gee" wrote: Click the letter A above your column of names. Hold down the shift key and click the header letter of the last column that you wish to sort. Data Sort ...... as previously described. George Gee "king_reggie" wrote in message ... That didnt work either...after i highlight the worksheet i go into Data but the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keeping the rows together
What's the possibility that you may have some underlying code?
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "king_reggie" wrote in message ... it's not protected. "George Gee" wrote: Faulty, no, probably not! Is the worksheet protected .... Tools Protection? George Gee "king_reggie" wrote in message ... it still won't let me select sort. do you think that my program is faulty? "George Gee" wrote: Click the letter A above your column of names. Hold down the shift key and click the header letter of the last column that you wish to sort. Data Sort ...... as previously described. George Gee "king_reggie" wrote in message ... That didnt work either...after i highlight the worksheet i go into Data but the Sort option is not available, i cant select it. i don't know whats going on...is there a way to do it without highlighting the whole worksheet? "Sameer Nagi" wrote: select the entire worksheet by "ctrl+A". select Data-Sort Select "Column A" in Ascending order...ensure that in "Options" it is selected to be columns and NOT rows... Let us know if this also doesnt work... "king_reggie" wrote: I'm Creating a directory based on new clientele and i want it alphabetical. now my problem is tha if i enter for example in A1 Kim Smith, B1 111 rogers rd, C1 555-555-5555, then continue with other names addresses and phone numbers, how can i get all the info per row to stay together when i sort column A? Is there a way to make the each column in the row work as one when it sorts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Data and Keeping format of rows | Excel Discussion (Misc queries) | |||
adding new rows and keeping same formulas | Excel Discussion (Misc queries) | |||
adding new rows and keeping the same formulas | Excel Worksheet Functions | |||
keeping rows intact during sort | Excel Discussion (Misc queries) | |||
Keeping duplicate rows | Excel Worksheet Functions |