lists in alphabetical order


Is there a way to put a list of products in alphabetical order?  I already
typed the stuff in and I would like to do this, if possible. It would make
life easier.



kdoye2112 (29)
6/8/2005 2:11:02 AM
excel 39879 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 52

Hi Bacchus,

With the typed product list selected (and associated columns), select the 
Sort option on the data menu.


"Bacchus" <> wrote in message
> Hi
> Is there a way to put a list of products in alphabetical order?  I already
> typed the stuff in and I would like to do this, if possible. It would make
> life easier.
> thanks
> -- 

normanjones (1047)
6/8/2005 2:25:40 AM

Similar Artilces:

Import Lists?
Is there a way to copy or import members (list of email addresses) from a Global Address List into a Excel spreadsheet? I've been able to put into a Word doc but it's not the results I'm looking for. Thanks!! You can use LDIFDE to run the query, you can then paste the results into an Excel spreadsheet. <> wrote in message news:490c01c49feb$cf922950$a401280a@phx.gbl... > Is there a way to copy or import members (list of email > addresses) from a Global Address List into a Excel > spreadsheet? I've been able to put into a Wo...

Where can I find a list of known CRM 1.2 issues and workarounds?
I am running a test of CRM 1.2 from MSDN Universal and I am having a number of minor strange issues. Is there a list of known problems, and workarounds posted anywhere? Have any patches been issued or other technical update articles? Is there some sort of monitored support newsgroup or something I should purchase to be able to more effectively evaluate the product? Thanks, Bill Walter This is the only public newsgroup on CRM apart from foreign language versions. For support you would need an agreement with Microsoft MBS. Feel free to ask any technical questions here as we normally can get...

Can Distribution List Sent Show Only One Recipient in Emails Recei
This is a re-write of a previous post, that didn’t get resolved. I’m restating it here to get a fresh start / better response. Also, please note that I’m not very technically savvy, so if there is a solve for this, please advise me in very plain language. Thanks in advance. Scenario: I'm a new user of Outlook 2007. Say I have a large group of clients. I want to create a boilerplate email for, that goes out to all the recipients. However, I want each email sent to be received by a single client, and at the same time not have that client be aware of the other clients (It...

Sort Order on Order Fulfillment Window
In the sales order fulfillment window you can sort the lines items by Order Entered or Site/Bin/Item. Does the Site/Bin/Item only sort by Bin if Multi-bin is used? I am not using multi-bin but have created bin for each item in each site on the Quantities/Sites window. thanks. ...

New items with purchase order integration
I'm running a daily integration to bring purchase orders into GP using Integration Manager. The source is a text file. It works very well. The problem I have is with new items. When there is an item in the source file that does not exist in Great Plains, I would like the integration to fail or skip the line item. Currently, it brings the item into the Purchase Order as a non inventory item. The document will show the item number and the cost but no item description. Where can I change the behavior for this? Unfortunately, with the users that put non-inventory items on POs Wh...

Problem on Outlook 2000 distribution list
I create a distribution list long time ago. It had 10 people on it. Last time I modify, add or delete people on distribution list, and I use this to send out. I found that the email only send to 3 people. It should be send to 10 different people. Please tell me why it will happen and how to solve it. Thanks a lot, Amon ...

Determining the apex of a order 2 polynomial
History: I created a spreadsheet with functions only that will provide feedback from a data point on an xy scatter chart. I charted several thousand cells with simple functions such that =if(and(a,b),1,0) to provide feedback based on these coordinates and then used v or h lookup to come up with the adjusted information. This is for a field determination of what the data points should produce. I thought it would be nice to duplicate the form for a similar process in the lab. We frequently test the field information to gain more exact information in the lab. This would allow me to show...

Change Order date?
I have situation where we had to enter some orders into CRM like 3 weeks after the fact but there was no way to to back date them when entering so that they fall into the proper months reports, etc. Any help out there on how I can change the dates at the database level? Look in the SalesOrderBase table. Mike "SteveT" <> wrote in message > I have situation where we had to enter some orders into CRM like 3 > weeks after the fact but there was no way to to back date them when > entering ...

Comparing first and last names in two lists #2
I have two data sources that each contain about 8000 names in seperate fields for first and last name. I can put them on seperate worksheets or append one to the other. I need to make them match and find out where they don't. Messed with consolidate but not sure if that will work for more than one column at a time. FYI data set one is from a school transportation database and data set two is from the main student database from the same school district. ------------------------------------------------ ~~ Message posted from ~~View and post usenet messages dir...

change order in which gwes loads display, touch, hid drivers
I cannot figure out how to do this, but I need GWES to load the display driver FIRST (for a splash screen implementation). Cannot find any registry values that accomplish this... any ideas? Come on guys, somebody has to know the order in which driver's are loaded by GWES.exe and how to alter it.... MS gentlemen???? I don't think that's going to help. What you really want to do is load the image in the bootloader, since, by the time GWES itself loads, you're probably 75% of the way through the boot process. As far as I can recall, GWES loads the keyboard, mouse, a...

Cannot see receipients in global list while using OWA
I have exchange 2003 with outlook 2003 as client. Whenever I use OWA and try to create new email and click on TO to select receiver's name from the global list, I get a differnent screen which as me to enter name to search. I want to display names so I can select from the list. Here is the screen that I get each time I click on TO. I should be seeing everyone's name so I can select. If I connect locally, I do get the list and there is no problem. This happens only with OWA. Thanks -------------------------------------------------------------------------------- OWA d...

Downloading in Outlook 2003 creates a file "needs list" instead of d/l file
When I have an email with attachment, and I go to download it, it downloads it and sometimes renames it to "needs list". It is the same size as the original file, however it cant be opened by any known program. In this case, it should be a .dwg autocad file, but it has happened a couple of times. the name in the saveas box is correct, you download it, and go to that directory and what you were expecting to be there isnt, instead needs list is there. Anyone here of this before? I searched Google, and the newsgroups and the MShelp files, and found nothing. Any ideas woul...

Why doesn't the page preview have the same order as work page?
Why doesn't the preveiw page look like the one I built on the work pages. I have "saved as" and "saved. The nagagation bars in preview goes to different pages than titled. HELP!!!!!! ...

Large List Sorting
Hello, All! Have a problem. I'm developing an application which reading a large database file (DBF) and displaying it in the list control. Because of the size of the file (>15 MB, later it will be increased) I'm using a virtual list (owner data). But now I need to sort data in the list. AFAIK to perfirm this I should read the whole file. In this case my program starts several minutes!!! It doesn't have to be like this [(C) Pink Floyd]... Is there any methods to load a large amount of data as quickly as possible? Or I just should humble, 'cause sorting of large amount of d...

Distribution Lists not replicating
We are preparing to migrate from exchange 5.5 to 2003. I am using the exdeploy tools and following all the steps. For some reason the only thing that is failing to replicate is the distribtion lists. When I open System Manager and look at the 5.5 mailboxes I don't see any of the distribtion there's no way I can move them to the 2003 server. Any ideas? Have you looked at this: ml "KJ" <> wrote in message news:025d01c499d3$c8b8f410$a601280a...

All Address Lists #2
I am trying to Hide the 'All Users' 'All Groups' and 'All Contacts' address lists below the 'All Address Lists' empty container, and provide company specific 'All' address lists instead. Every time I try to hide the non-required address lists, they are still visible to users, and when they try to view the list the error 'This Bookmark Is Not Valid' is presented. Is there a way to either filter the 'All Users etc..' address lists so that one domain can only see thier own domain? or is there a successful way to 'hide' the li...

Insert list of figures does not work for Pictures
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I can generate a list of all of my inserted objects by caption: Figure, Example, Table, Song, Chart. But when I try to generate a list of the pictures I have inserted (caption reads Picture ...), I get the following message: Error! No table of figures entries found. It's as if the macro that reads the caption list doesn't have Picture in its internal dictionary. I do have the Picture captions in a text box that is formatted as "tight" to allow text-wraparound; could that be causing the problem? If so h...

Hi, In Excel 2003, one could to create a new menu and then choose commands for such new menu. I used to create a list of files to open (different from the "most recent" list). How does one do it in Excel 2007? Thanks. "CF" <> wrote in message > Hi, > In Excel 2003, one could to create a new menu and then choose commands for > such new menu. I used to create a list of files to open (different from > the > "most recent" list). > &g...

Lost contact list 04-22-10
I amusing Windows live had no problem picking up my contacts from Outlook Express. Now that I syncronized messages from my Hotmail e-mail account and my Telus email account into Windows Live, my contact list is only the two contacts from the hotmail account. All the rest are gone. They are still in the Address Book, but I cant access them How can I get it back into Windows Live Mail ??? Help please. You signed into the Hotmail account when you started Windows Live Mail. This is optional and not at all related to getting your mail. When you sign in, WLM sync...

Send Emails With A Different Name Than How Its Listed in the GAL
Hi all, I have a quick question: My client is unhappy with how his emails get sent out from MS Outlook. The GAL on our server lists names as [Last Name], [First Name]. This is how the majority of our clients want it. However, he wants his to be [First Name] [Last Name]. So, all recipients getting emails from him will see his name as First Name, Last Name. We can't do this for him on our GAL, since it would obviously cause an inconsistency if we did it only for one name. But, I figured I'd post here to see if anything else can be done to accomodate him. Thanks in advance for your help...

ditribution list
hi all, i need to create a list of contact from an outlook contact to exchange. this because i need to centralize the address contact to global address list on exchange. all of this contact will be sent via outlook with an external isp account. can i create this type of distribution list on exchange or it is more simple to share one outlook contact to other. thanks Giulio Hi, If you create mail enabled contacts in your AD then they will be published to you GAL. That is under the presumtion you do not have any custom GALs, AD issues etc etc. Oliver You can also share address books...

Suppliers with Top Items List
Can anyone let me know how to show suppliers on Top Item List? I badly need this. I tried my way but not successful. -- Many Thanks Install the RMS Toolkit trial download you requested and check off Custom Reports/Templates during installation. Now run Manager, Reports, Custom, Top Items Report. This report includes Suppliers, Dept, Category, and Sub-Descriptions as columns and filter options. There are over 100 free reports and templates included with our RMS Toolkit trial. Visit: Greg Digital Retail Solutions (v1.x and ...

Importing List from Excel to Word printing labels spacing problems
When I import my mailing list from Excel to Word to print mailing labels (30 per page) my labels have large spaces between the lines. For example they look like this: John Doe P.O. Box 000 City, State, Zip And then if I have a business name before John Doe it gets cut off. Is there a way to decrease the space between the lines so it fits better? I have figured out how to do one at a time, but we have 4,000 of these to print! I would like it to look like: John Doe P.O. Box 000 City, State, Zip Thanks for any help! Sounds like a question for a Word newsgroup, not...

What file to look for on my hard drive back up to recover my Entourage contact list?
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Hi, <br><br>I have a back up of all my hard drive on a back up drive. Good news. <br><br>But... <br><br>I just had a new drive installed and I had to re-install Entourage (too long to explain why), and I my Entourage contacts were not transferred to the new drive. <br><br>I want to import my contact file from my back up drive but I don't know what file to look for and where to look for. <br><br>Any suggestion? Thanks On 2/6/10 6:45 AM, in article 59bb259f.-1@webc...

drop down lists in Business Portal
When requiring a query selection for filtering (such as in Purchase Request), the go button (right arrow on green background) should be automatically pressed when a selection is clicked. I think it would be as simple as adding an 'on changed' event to the drop down list to call the button, and would make the user interface more intuitive and comfortable (less frustration than if you're waiting for your results and not realize you didn't hit the button). ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most vote...