regarding pivot table. select the entire range of date using ctrl+shift+end. press alt+n, go to insert menu, press v for table and t for pivot table. one dialogue box will come there, keep default options as it is and press ok button. a new sheet is created and you land on a3 of that sheet. press alt. then press ctrl+tab. a list will appear where collumn headings are available. press application key on each column heading and choose to add in row or column.
On 8/23/14, Him Prasad Gautam <drishtibac...@gmail.com> wrote: > hi, > Be clear first: > What do you want? > 1. just sort a single column. > 2. Sort multiple column first one then other then other etc. > 3. Order of sorting ascending or descending. > 4. Does the sheet contain the column title at the top or not? > Based on these cases, do: > 1. select any cell (better row one but not compulsory!) of that column > which you want to sort. > In case of multiple column sorting, select the first column of first order. > 2. press alt+h s. (home menu and then sort and filter submenu. > now, if single column: > choose from smaller to larger or Larger to smaller as per your need. > If multiple column: > select customize and define the order of column, sorting order, > contains title or not etc. > Remember that: > If the value of a column are sorted, all the rest values of the same > row of rest column will be automatically rearranged. > In future, Help others as I did you! > Enjoy. > > > On 8/23/14, Adhimoolam Vetrivel Murugan <vadhimoo...@gmail.com> wrote: >> Hi, Office 2010 pro. >> >> Vetri. >> >> On 23/08/2014, Him Prasad Gautam <drishtibac...@gmail.com> wrote: >>> hi, >>> First make clear which version of MS office are you using. >>> >>> >>> On 8/22/14, Adhimoolam Vetrivel Murugan <vadhimoo...@gmail.com> wrote: >>>> Hey all, >>>> >>>> Great to write to the list after a very long time! I need help with >>>> excel sheat in completing an assignment. Could someone explain step by >>>> step instruction in sorting data for a single colunm from a table >>>> containing 4 colunms and 12 rows. Second, I would also need help with >>>> Pivot Table. Any help is greatly appriciated. >>>> >>>> Thanks and Regards, >>>> >>>> Vetri. >>>> >>>> >>>> >>>> Register at the dedicated AccessIndia list for discussing accessibility >>>> of >>>> mobile phones / Tabs on: >>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>>> >>>> To unsubscribe send a message to >>>> accessindia-requ...@accessindia.org.in >>>> with the subject unsubscribe. >>>> >>>> To change your subscription to digest mode or make any other changes, >>>> please >>>> visit the list home page at >>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>> >>>> >>>> Disclaimer: >>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>> of >>>> the >>>> person sending the mail and AI in no way relates itself to its >>>> veracity; >>>> >>>> 2. AI cannot be held liable for any commission/omission based on the >>>> mails >>>> sent through this mailing list.. >>>> >>> >>> >>> -- >>> Him Prasad Gautam >>> Kathmandu, Nepal >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > -- > Him Prasad Gautam > Kathmandu, Nepal > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- nothing is difficult unless you make it appear so. r. aravind, D R O in bank of baroda, mobile no: +91 9940369593, email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.com. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..