thanks alot sir. On Thu, Sep 15, 2011 at 5:47 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote:
> To find a merged cell in Excel 2003. > > 1. Open a Find and Replace Menu. > 2. Next to the Find What Field is a Format Box, Click it. > 3. This opens the Find Format Menu screen which looks very similar to the > Cell Format Tabs and screens > 4. On the Alignment Tab, remove any ticks in the Wrap Text or Shrink to Fit > boxes. > 5. Leave a tick in the Merge Cells Box and click the OK Button to return to > the Find and Replace screen. > 6. Now click the Find All Button and ALL merged cells are shown in the > lower > window and are selectable to jump to their location > > > > http://www.pcreview.co.uk/forums/do-locate-merged-cells-my-excel-worksheet-t3785983.html > > On Thu, Sep 15, 2011 at 1:15 PM, Amit Gandhi <silkyro...@gmail.com> wrote: > >> Hi Folks >> >> I am finding some problem in excel data. Pls help me here. I have a excel >> data in 10 columns and 20000 rows. There are some MERGED CELLS in this data. >> I am applying filters and its not working due to merged data. Is there any >> way in Excel to find merged cells automatically. >> >> Pls help me here. >> >> Regards >> >> Amit >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *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 > -- 'Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian. Think about it.' Take care Amit -- ---------------------------------------------------------------------------------- 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