There is no shortcut key to do this, but you can press Alt + W + F + F in Excel 2007 to access menu options to toggle between freeze and unfreeze panes.
-----Original Message----- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Vikas Kapoor Sent: 29 September 2012 20:14 To: accessindia@accessindia.org.in Subject: Re: [AI] Friends a small query while working on an Excel sheet likewise, are there any shortcuts for freezing or unfreezing a selected column or a row? ----- Original Message ----- From: "Syed Imran" <syed.f...@gmail.com> To: <accessindia@accessindia.org.in> Sent: Saturday, September 29, 2012 7:41 PM Subject: Re: [AI] Friends a small query while working on an Excel sheet Shortcut keys: Ctrl + 9 - hide the selected rows Ctrl + 0 - hide the selected columns Ctrl + shift + 9 - unhide the selected rows Ctrl + shift + 0 - unhide the selected columns. -----Original Message----- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mukesh Sent: 29 September 2012 17:45 To: accessindia@accessindia.org.in Subject: Re: [AI] Friends a small query while working on an Excel sheet To hide column: Select the particular column exa. column 'D' and press application key-hide-enter-done. To unhide it: Select the adjacent column of that particular column exa. columns 'C to E' and press application key-unhide-enter-done. Good luck! Regards Mukesh Baviskar Mobile: 9403161157 -------------------------------------------------- From: "tiku raj" <tiku...@gmail.com> Sent: Saturday, September 29, 2012 5:10 PM To: "accessindia" <accessindia@accessindia.org.in> Subject: [AI] Friends a small query while working on an Excel sheet > Hi Friends, > > Hope all are fine and doing good. > > Today while working on an Excel sheet i faced a small problem. > > I wanted to hide few columns which had some data which I did wanted to > be on the screen, I did this using hide optionusing application key, > but when I wanted to unhide this same data i was unable to do it. > > I could not understand where I was wrong. > > Please come forward and guide me with steps how to hide a data in few > columns and rows and how to unhide the same. > > Thanks in advance. > > Regards, > > Tiku > > > 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 > 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 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 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 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
