Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
HOW TO: Work with an HTML Table That Contains Merged Cells in Excel 2000
Article ID: 275611 - View products that this article applies to.
This article was previously published under Q275611
This article describes how to import a Hypertext Markup Language (HTML) table and unmerge any cells, so that Excel 2000 can filter and sort the data.
Although you can import HTML tables into Excel, many HTML tables use merged cells that prevent Excel from sorting or filtering the data.
For more information about merged cells, click Microsoft Excel Help on the Help menu, type split a merged cell into separate cells in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For additional information about related topics, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/210320/EN-US/ )XL: Web Page Saved in Excel Displays Differently in Web Browser
211710For additional information about problems when you open Excel files in Microsoft Internet Explorer, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/211710/EN-US/ )XL2000: Cells in a Protected Worksheet May Become Unmerged
(http://support.microsoft.com/kb/200704/EN-US/ )XL2000: Error Opening Excel File from Internet Explorer Address Bar