Article ID: 2643843 - View products that this article applies to.
Consider the following scenario in Microsoft Office Excel 2010:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
We recommend you follow one of these methods to work around this problem:
Method 1: Click and hold the mouse button when you click the row heading.When you select the row heading, click and hold the mouse button on the row heading instead of using a single click. At first, multiple rows will be selected, but shortly afterward, the selection will revert to the single row you selected.
Method 2: Scroll the pageScroll the page left or right so that the rows containing the merged cells in the frozen area are not next to the row headings.