This is something really new thanks for the same
Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Rajesh Kunder Sent: 19 June 2009 09:27 am To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ <BEST EXCEL TIP> <WEEK # 25> <Submit your TIP here only> Options Hi, Name: Rajesh Kunder TIP: Identifying Merged Cells Please follow the below mentioned steps to identify all merged cells in excel at one shot ! 1. Ctrl+F. Excel displays the Find tab of the Find and Replace dialog box. 2. If necessary, 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. Now its very easy if you want to delete or unmerge all the merged cells. Regards, Rajesh Kunder The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
