*Short Key* *Activity* Alt+A+Q Advance Filter Alt+D+F+A Advance Filter Alt+D+P Pivot Table Alt+E+I+S Fill Series Alt+E+L Delete Sheet Alt+H+B For Border Alt+H+F Font Colour Alt+H+F+P Format Painter Alt+H+FF Font Alt+H+FS Font Size Alt+H+H Them Colour Alt+H+I Insert Alt+H+L Conditional Formating Alt+H+S Sort Normally Alt+D+S Sorting Alt+M+M+D Define Name Alt+M+N Name Manager Alt+N+C Insert Column Chart Alt+N+E Pie Chart Alt+N+E Bar Chart Alt+N+K Insert Chart Alt+N+N Line Chart Alt+N+V+C Pivot Chart Alt+N+V+T Pivot Table Alt+O+DL Conditional Formating Alt+O+H+R Rename Of Sheet Alt+E+L Delete Current Sheet Alt+R+P+S Protect Sheet Alt+T+G Goal Seak Alt+W+F+F Freeze Alt+D+E Text To Column Alt+A+E Text To Column Alt+D+L Data Validation Alt+A+V+V Data Validation CTRL+9 Hides The Selected Rows. CTRL+0 Hides The Selected Columns. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel