 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007keeping 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? 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.  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== 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? It didn't happen. the text in column B stays put and only Colum A sorts > Simply select the *entire* datalist before you sort. > [quoted text clipped - 9 lines] > column A? Is there a way to make the each column in the row work as one when > it sorts? 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... > 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? 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? > select the entire worksheet by "ctrl+A". > select Data->Sort [quoted text clipped - 9 lines] > > column A? Is there a way to make the each column in the row work as one when > > it sorts? 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 > That didnt work either...after i highlight the worksheet i go into Data > but [quoted text clipped - 19 lines] >> > when >> > it sorts? it still won't let me select sort. do you think that my program is faulty? > Click the letter A above your column of names. > Hold down the shift key and click the header letter of the last column that [quoted text clipped - 27 lines] > >> > when > >> > it sorts? I don't think your program is faulty. I think that your sheet is "Protected". <Tools> <Protection> <Unprotect Sheet> You may need a password! SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== 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 [quoted text clipped - 34 lines] > >> > when > >> > it sorts? Faulty, no, probably not! Is the worksheet protected .... Tools > Protection? George Gee > it still won't let me select sort. do you think that my program is faulty? > [quoted text clipped - 32 lines] >> >> > when >> >> > it sorts? it's not protected. > Faulty, no, probably not! > Is the worksheet protected .... Tools > Protection? [quoted text clipped - 37 lines] > >> >> > when > >> >> > it sorts? What's the possibility that you may have some underlying code? SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > it's not protected. > [quoted text clipped - 39 lines] > > >> >> > when > > >> >> > it sorts? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.