In the case of first or last column/row, you need to select all the columns/rows by pressing control space and shift space as the case is. ----- Original Message ----- From: Raghvendra N via AI To: Connect, share and enrich Cc: Raghvendra N Sent: Thursday, May 04, 2017 4:34 PM Subject: Re: [Ai] How To Hide Columns On Excel 2007.
Thank you sir! But, it is not working for 1st column / row. On 5/3/17, Vikas Kapoor via AI <ai@accessindia.inclusivehabitat.in> wrote: > To be able to unhide a column or a row, you first need to select both the > columns or rows adjacent to the hidden items. For example, if A 6 is hidden, > you need to first select A 5 and A 7 then only perform the required key > combinations for unhiding a row or a column. > ----- Original Message ----- > From: Raghvendra N via AI > To: Connect, share and enrich > Cc: Raghvendra N > Sent: Wednesday, May 03, 2017 1:29 PM > Subject: Re: [Ai] How To Hide Columns On Excel 2007. > > > control+shift+9/0 is not working in my sheet. But, other wise is > working. Is this problem with the settings? > > > On 5/2/17, Dr. B. S. M. Kumar via AI <ai@accessindia.inclusivehabitat.in> > wrote: > > Thanks Vikas and Aravind for your response. > > Both the commands worked perfectly. > > Regards, > > > > > > Prof. B.S.M. Kumar, M.Sc., M.Tech., PhD. > > Director (Industry and Education Relationship), Project Starfish > > Email: kumar....@pstarfish.org > > Linkedin: https://in.linkedin.com/in/dr-kumar-bsm-39887864 > > Twitter: @BSMKumar1 > > Cell: +91-9840139849 > > Skype: bsm.kumar > > | > > www.pstarfish.org > > | > > "An integrated opportunity and employment platform for the blind and A > > shared service for business and start-ups" > > > > -----Original Message----- > > From: AI [mailto:ai-boun...@accessindia.inclusivehabitat.in] On Behalf > Of > > Vikas Kapoor via AI > > Sent: 02 May 2017 18:07 > > To: Connect, share and enrich > > Cc: Vikas Kapoor > > Subject: Re: [Ai] How To Hide Columns On Excel 2007. > > > > Alternatively, press control+9 to hide columns and control +0 to hide a > row > > ,and shift+control +9 and 0 to unhide the same. > > ----- Original Message ----- > > From: Dr. B. S. M. Kumar via AI > > To: 'Connect, share and enrich' > > Cc: Dr. B. S. M. Kumar > > Sent: Tuesday, May 02, 2017 12:20 PM > > Subject: Re: [Ai] How To Hide Columns On Excel 2007. > > > > > > Thanks Aravind for your reply. I'll try this and come back with my > > experiences. > > Regards, > > > > > > Prof. B.S.M. Kumar, M.Sc., M.Tech., PhD. > > Director (Industry and Education Relationship), Project Starfish > > Email: kumar....@pstarfish.org > > Linkedin: https://in.linkedin.com/in/dr-kumar-bsm-39887864 > > Twitter: @BSMKumar1 > > Cell: +91-9840139849 > > Skype: bsm.kumar > > | > > www.pstarfish.org > > | > > "An integrated opportunity and employment platform for the blind and > A > > shared service for business and start-ups" > > > > -----Original Message----- > > From: AI [mailto:ai-boun...@accessindia.inclusivehabitat.in] On Behalf > Of > > Aravind R via AI > > Sent: 02 May 2017 11:46 > > To: Connect, share and enrich > > Cc: Aravind R > > Subject: Re: [Ai] How To Hide Columns On Excel 2007. > > > > press alt then press h, then press o and press u. then follow the > > instructions by pressing up and down arrows. <div > > id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> > > <table style="border-top: 1px solid #D3D4DE;"> > > <tr> > > <td style="width: 55px; padding-top: 13px;"><a > > > > > href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c > > ampaign=sig-email&utm_content=webmail" > > target="_blank"><img > > > > > src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-a > > nimated-no-repeat-v1.gif" > > width="46" height="29" style="width: 46px; height: 29px;" /></a></td> > > <td style="width: 470px; padding-top: 12px; color: #41424e; > > font-size: 13px; font-family: Arial, Helvetica, sans-serif; > > line-height: 18px;">Virus-free. <a > > > > > href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c > > ampaign=sig-email&utm_content=webmail" > > target="_blank" style="color: #4453ea;">www.avast.com</a> > > </td> > > </tr> > > </table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" > > height="1"></a></div> > > > > On 5/2/17, Dr. B. S. M. Kumar via AI > <ai@accessindia.inclusivehabitat.in> > > wrote: > > > Hi All, > > > > > > Can anyone suggest step by step key commands for hiding columns on > > > Excel2007. > > > > > > Let me clarify it more: Say I have data on columns A through G. Now, > I > > want > > > to hide the informations on the columns C through F. > > > > > > Kindly let me know the steps to accomplish the same. Also, kindly > > indicate > > > the commands to re-show the hidden columns. > > > > > > I'm using windows7 32 bit, office 2007 with JAWS16. > > > > > > Hope to receive a favourable reply. > > > > > > Thanking you in advance. > > > > > > Kind regards, > > > > > > > > > > > > > > > > > > Prof. B.S.M. Kumar, M.Sc., M.Tech., PhD. > > > > > > Director (Industry and Education Relationship), Project Starfish > > > > > > Email: drbsmku...@gmail.com > > > > > > Linkedin: https://in.linkedin.com/in/dr-kumar-bsm-39887864 > > > > > > Twitter: @BSMKumar1 > > > > > > Cell: +91-9840139849 > > > > > > Skype: bsm.kumar > > > > > > | > > > > > > www.pstarfish.org > > > > > > | > > > > > > "An integrated opportunity and employment platform for the blind and > A > > > shared service for business and start-ups" > > > > > > > > > > > > -------------- next part -------------- > > > An HTML attachment was scrubbed... > > > URL: > > > > > > > > <http://accessindia.inclusivehabitat.in/pipermail/ai_accessindia.inclusiveha > > bitat.in/attachments/20170502/186a0c00/attachment.html> > > > _______ > > > > > > > > > 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.. > > > > > > Search for old postings from the new domain at: > > > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > > > > > Search for posts from the old domain at: > > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > > > > > > > > > > > ________________________________________ > > > AI mailing list > > > AI@accessindia.inclusivehabitat.in > > > > > > > > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclu > > sivehabitat.in > > > > > > > > > -- > > nothing is difficult unless you make it appear so. > > > > r. aravind, > > > > Assistant manager > > Department of sales > > bank of baroda retail loan factory, Chennai. > > mobile no: +91 9940369593, 9710945613. > > email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.com. > > > > _______ > > > > > > 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.. > > > > Search for old postings from the new domain at: > > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > > > Search for posts from the old domain at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > > > > > > ________________________________________ > > AI mailing list > > AI@accessindia.inclusivehabitat.in > > > > > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclu > > sivehabitat.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.. > > > > Search for old postings from the new domain at: > > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > > > Search for posts from the old domain at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > > > > > > ________________________________________ > > AI mailing list > > AI@accessindia.inclusivehabitat.in > > > > > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclu > > sivehabitat.in > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > > > <http://accessindia.inclusivehabitat.in/pipermail/ai_accessindia.inclusiveha > > bitat.in/attachments/20170502/949f69ed/attachment.html> > > _______ > > > > > > 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.. > > > > Search for old postings from the new domain at: > > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > > > Search for posts from the old domain at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > > > > > > ________________________________________ > > AI mailing list > > AI@accessindia.inclusivehabitat.in > > > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclu > > sivehabitat.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.. > > > > Search for old postings from the new domain at: > > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > > > Search for posts from the old domain at: > > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > > > > > > ________________________________________ > > AI mailing list > > AI@accessindia.inclusivehabitat.in > > > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclusivehabitat.in > > > > > -- > With thanks, Raghavendra N > > Administrative Officer Umex dept - RO Bengaluru > > Mob: 9986717899 > > _______ > > > 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.. > > Search for old postings from the new domain at: > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > Search for posts from the old domain at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > ________________________________________ > AI mailing list > AI@accessindia.inclusivehabitat.in > > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclusivehabitat.in > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://accessindia.inclusivehabitat.in/pipermail/ai_accessindia.inclusivehabitat.in/attachments/20170503/7d4341b7/attachment.html> > _______ > > > 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.. > > Search for old postings from the new domain at: > https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in > > Search for posts from the old domain at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > > > > ________________________________________ > AI mailing list > AI@accessindia.inclusivehabitat.in > http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclusivehabitat.in > -- With thanks, Raghavendra N Administrative Officer Umex dept - RO Bengaluru Mob: 9986717899 _______ 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.. Search for old postings from the new domain at: https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in Search for posts from the old domain at: http://www.mail-archive.com/accessindia@accessindia.org.in/ ________________________________________ AI mailing list AI@accessindia.inclusivehabitat.in http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclusivehabitat.in -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://accessindia.inclusivehabitat.in/pipermail/ai_accessindia.inclusivehabitat.in/attachments/20170504/f672446a/attachment.html> _______ 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.. Search for old postings from the new domain at: https://www.mail-archive.com/ai@accessindia.inclusivehabitat.in Search for posts from the old domain at: http://www.mail-archive.com/accessindia@accessindia.org.in/ ________________________________________ AI mailing list AI@accessindia.inclusivehabitat.in http://accessindia.inclusivehabitat.in/mailman/listinfo/ai_accessindia.inclusivehabitat.in