it is found under windows menu freeze pans . just have your focus on the cell for which you need to freeze and then move to windows menu to hit freeze pans. it's done.
On 7/12/12, Vikas Kapoor <[email protected]> wrote: > Could somebody also be kind enough to let me know the procedure in excel > 2003 to freeze a particular row or column so that it remains visible on the > > screen despite we scroll down the sheet? > ----- Original Message ----- > From: "Radha" <[email protected]> > To: "mamta" <[email protected]>; > <[email protected]> > Sent: Thursday, July 12, 2012 11:38 AM > Subject: Re: [AI] Doubt in Excel 2003 > > > Hello Tanya, > we don't have 2007 shortcut key in 2003 for hiding and unhiding rows > or columns. so to perform in 2003, can use the above methods said by > our mates. > just for your reference the 2007 shortcut keys : > ctrl+9 Hides the selected rows. > ctrl+0 Hides the selected columns. > ctrl+shift+( Unhides any hidden rows within the selection. > ctrl+shift+) Unhides any hidden columns within the selection. > this shortcut key is applicable in excel 2010 and in 2011 in MAC os. > > > > > On 7/12/12, mamta <[email protected]> wrote: >> Hi! answerring your question: >> >> First open excel go to format menu and then keep the cursor on the sheet >> which you want to hide. >> >> Press alt and o to go the format menu >> press H to go to the sheets sub menu, >> >> There you will find options like rename, hide, un hide, >> >> hot key for hiding is H and for unhide is U. >> >> once you press the desired options then your sheet will be hidden or un >> hidden immediately. >> >> You can also hide more than one sheet at a time. >> >> Hope you understand. >> >> Do feel free to get back if you need any more help. >> >> Thanks a lot. >> >> "Disabilities create barriers, but determination breaks them". >> >> Hellen Keller. >> >> P Go Green: DO NOT print this e-mail unless absolutely necessary >> >> With thanks and regards. >> >> Mamta. >> >> STATE BANK OF INDIA >> ANDHERI WEST. >> Mumbai! >> >> ----- Original Message ----- >> From: "Tanya" <[email protected]> >> To: <[email protected]> >> Sent: Thursday, July 12, 2012 9:02 AM >> Subject: [AI] Doubt in Excel 2003 >> >> >> >> >> Hey all, >> >> Hope you guys are enjoying the monsoons. What I'd like to know is, do the >> keystrokes for hiding columns and rows in Excel 2007 work in 2003 as >> well? >> Also, what is the keystroke to hide/unhide sheets in Excel 2003? Please >> let >> me know. >> >> Thanks guys. Have a wonderful day, >> >> Tanya >> >> >> >> >> >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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 --- The information in this mail is confidential and is >> intended solely for addressee. Access to this mail by anyone else is >> unauthorised. Copying or further distribution beyond the original >> recipient >> may be unlawful. Any opinion expressed in this mail is that of sender and >> does not necessarily reflect that of State Bank group. --- >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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 >> >> > > > -- > Cheers, > Radha > Never give up until your dreams are reached, keep dreaming then. > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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 > > -- Cheers, Radha Never give up until your dreams are reached, keep dreaming then. Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] 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
