Re: [AI] A big hello to everyone and an Excel question
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 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 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 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 wrote: Hi, Office 2010 pro. Vetri. On 23/08/2014, Him Prasad Gautam wrote: > hi, > First make clear which version of MS office are you using. > > > On 8/22/14, Adhimoolam Vetrivel Murugan 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
Re: [AI] A big hello to everyone and an Excel question
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 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 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 wrote: >>> Hi, Office 2010 pro. >>> >>> Vetri. >>> >>> On 23/08/2014, Him Prasad Gautam wrote: hi, First make clear which version of MS office are you using. On 8/22/14, Adhimoolam Vetrivel Murugan 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 t
Re: [AI] A big hello to everyone and an Excel question
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 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 wrote: >> Hi, Office 2010 pro. >> >> Vetri. >> >> On 23/08/2014, Him Prasad Gautam wrote: >>> hi, >>> First make clear which version of MS office are you using. >>> >>> >>> On 8/22/14, Adhimoolam Vetrivel Murugan 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
Re: [AI] A big hello to everyone and an Excel question
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 wrote: > Hi, Office 2010 pro. > > Vetri. > > On 23/08/2014, Him Prasad Gautam wrote: >> hi, >> First make clear which version of MS office are you using. >> >> >> On 8/22/14, Adhimoolam Vetrivel Murugan 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 other
Re: [AI] A big hello to everyone and an Excel question
Hi, Office 2010 pro. Vetri. On 23/08/2014, Him Prasad Gautam wrote: > hi, > First make clear which version of MS office are you using. > > > On 8/22/14, Adhimoolam Vetrivel Murugan 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..
Re: [AI] A big hello to everyone and an Excel question
hi, First make clear which version of MS office are you using. On 8/22/14, Adhimoolam Vetrivel Murugan 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..
[AI] A big hello to everyone and an Excel question
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..