Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Additional columns or rows that are not selected may be added to the print titles when you create print titles on a worksheet in Excel


View products that this article applies to.

This article was previously published under Q211557
For a Microsoft Excel 97 version of this article, see 156983 (http://support.microsoft.com/kb/156983/ ) .
For a Microsoft Excel 97 version of this article, see 156983 (http://support.microsoft.com/kb/156983/ ) .

↑ Back to the top


Symptoms

When you create print titles on a worksheet in Microsoft Excel, additional columns or rows that are not selected may be added to the print titles.

↑ Back to the top


Cause

This issue may occur when you use the mouse to select columns or rows for print titles, and the selected columns or rows contain merged cells that extend into other columns or rows.

↑ Back to the top


Workaround

To work around this issue, type a range for print titles on the Sheet tab of the Page Setup dialog box, rather than selecting the range with the mouse. To do this, follow these steps:
  1. In Microsoft Office Excel 2003 and in earlier versions of Excel, click Page Setup on the File menu.

    In Microsoft Office Excel 2007, click the Page Layout tab, and then click Page Setup to open the Page Setup dialog box.
  2. Click the Sheet tab.
  3. In the Rows to repeat at top or Columns to repeat at left box, type the range that you want to use for print titles. Do not select the range with the mouse.

    For example, if you want column A to be repeated at the left edge of each printed page, type the following text in the Columns to repeat at left box:
    $A:$A
    If you want rows 1 through 3 to be repeated at the top of every printed page, type the following text in the Rows to repeat at top box:
    $1:$3
  4. Click OK.

↑ Back to the top


More information

When you select cells for print titles by using the mouse, and when the column or row that you select contains a merged cell that extends into other columns or rows, the other columns or rows are also included in the selection.

For example, if you merge cells A16:D16 and then select column A with the mouse, columns B, C, and D are also selected because the merged cell extends into these columns.

You can merge a group of cells into a single cell in Excel. To merge a group of cells, follow these steps:
  1. Right-click the cells that you want to merge, and then click Format Cells.
  2. Click the Alignment tab.
  3. Click to select the Merge cells check box, and then click OK.

↑ Back to the top


Keywords: KB211557, kbprb, kbfaq

↑ Back to the top

Article Info
Article ID : 211557
Revision : 5
Created on : 1/23/2007
Published on : 1/23/2007
Exists online : False
Views : 392