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
