Thanks Ayush and everyone :-) Regards, Rajesh Kunder
On Mon, Jun 22, 2009 at 7:49 PM, Ayush <jainayus...@gmail.com> wrote: > > Hello Everyone, > > Please congratulate Rajesh Kunder for winning the Best Excel Tip award > of Week # 25. This is really great news that people are participating > in the weekly tip contest and sharing amazing tips and tricks. > > The tip submitted by Rajesh is as follows : > > Subject : Identifying Merged Cells > Tip : > 1. *Ctrl+F*. Excel displays the Find tab of the Find and Replace > dialog box. > 2. Click the Options button to make sure the Find and Replace > dialog box is expanded to show all options. > 3. Make sure the Find What box is empty. > 4. With the insertion point in the Find What box, click the Format > button. Excel displays the Find Format dialog box. > 5. Make sure the Alignment tab is displayed. > 6. Make sure the Merge Cells check box is selected (there should be > a check in the check box). > 7. Click OK to close the Find Format dialog box. > 8. Click Find All. > > This is new, productive and unique tip among all the tips by the > participants. I encourage you all to submit such great tips which will > help all members and let you win the prize. > > MANY MANY CONGRATULATIONS RAJESH !!!!!!!!!! KEEP IT > UP !!!!!!!!!!!!!!!!! > You are now nominated for monthly award and your name is published on > home page of this group. > > CHEERS !!! > > The competition of week # 26 is already started & you can submit your > tip in the thread mentioned below: > > http://groups.google.com/group/excel-macros/browse_thread/thread/7bd29ef9c24174fc/c3b3a8fa4d2ebeec#c3b3a8fa4d2ebeec > > Please participate and win wonderful prizes. > > KEEP POSTING !!!! > > Thanks and best regards, > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---