Hello EveryOne, I am Aakash from Mumbai. Tip for the Competition: Use Control and Key No. '1' i.e Control+1, which is a shortcut for formatting cells the way u want like formatting font, colour, border, merge cells, wrap text, text orientation etc. Try it out.. I often use this! Regards, Aakash Mumbai +91-9773272789.
--- On Fri, 6/5/09, Ayush <jainayus...@gmail.com> wrote: From: Ayush <jainayus...@gmail.com> Subject: $$Excel-Macros$$ <BEST EXCEL TIP> <WEEK # 24> <Submit TIP and Win PRIZE> To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Friday, June 5, 2009, 9:11 PM Hello Everyone, Please submit your tip in this post for Week # 24. I am looking for your overwhelming response in this competition.You just need to submit your name along with the tip and subject. The tip can be shortcut, trick, hidden secret, etc. Last Submission Date -----13th June 2009. Winner Declaration Date -----14th June 2009. Example : Name : Ayush Jain Subject : the Great 'F4' Tip : The 'F4' is easily the most useful shortcut key in Excel. Basically it repeats your last command. So say you changed the color of a font in a cell. Now click in a new cell and hit 'F4' and it will change the font in the new cell to the same color.Wonderful, right? Well what's great about this is that it works for nearly everything else in Excel too.Highlight a row, right- click and choose 'Delete'. Now highlight another row and hit 'F4'. It deletes that row.Whatever you did last, Excel will attempt to repeat the same command until you do something else. This works great for things that require you to go to the menus or right-click and make choices or click buttons that bring up more dialogs. It can be huge time saver once you get used to using it. As the help says, it doesn't work in every situation but most times 'F4' works great. SO, WHAT ARE YOU WAITING FOR ? JUST SUBMIT A TIP & WIN PRIZES. Invite your friends too for participation in the contest. The more participation means more learning. Thanks again, Ayush Jain --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---