If I understand you correctly, you have information stored in an Excel spreadsheet. Each row is one complete record. You want to sort/arrange the rows by the information you have stored in Column F. If this is correct, you can do the following:
Move your cursor to the first row of data in column F, or if you have a header row, place the cursor on the header for Column F. >From the menu bar open the Data menu and navigate to sort. I think it is the first item. A dialog box will open. JAWS 8 and 9 act a bit odd when reading some of the fields in this dialog box. You will be able to select the column you want to sort on. You will either see the header names or the column letter. Hopefully by placing your cursor on the header of column F, you will see the columns names instead of the letters. Sometimes you have to tab away from a field and back again in this dialog box to hear what is in it. There are a few other fields you can change that will effect your sort. Just let me know if you need help figuring any of these out. HTH, Annette -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ann Marie Medlar Sent: Friday, February 06, 2009 3:46 PM To: JawsUsersList Subject: [JAWS-Users] Excel sorting summarizing Hi Folks, Just wondering if anyone knows how to do folloing in Excel? I created a spreadsheet that tracks where I go on my PC. The file is called PFirelog.xlc. In column f there is a IP address but many of IP addresses are the same. So I would like to sort on column f and only have 1 line per IP address. Does anyone know how to do this in Excel? Thanks, Ann Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [email protected] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [email protected] Use the following address in order to contact the management team [email protected] If you wish to join the Blind Computing list send a blank email to the following address: [email protected] Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [email protected] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [email protected] Use the following address in order to contact the management team [email protected] If you wish to join the Blind Computing list send a blank email to the following address: [email protected]
