Hi Friends, One more query how to use pivot table in Microsoft Excel 2003 & 2007.
Please guide step by step if any of the list members are aware of it. Regards, Tiku On 8/23/14, Aravind R <aravind.andhrab...@gmail.com> wrote: > 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.. > 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..