for office 2007 and 2010. > 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/24/14, tiku raj <tiku...@gmail.com> wrote: > 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.. > -- 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..