Microsoft KB Archive Search

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.

  1. Home
  2. You cannot use the AutoFit feature for rows or columns that contain merged cells in Excel

You cannot use the AutoFit feature for rows or columns that contain merged cells in Excel

For a Microsoft Excel 98 version and a Microsoft Excel 2001 for Mac version of this article, see 179045 .

↑ Back to the top

Symptoms

You may be unable to use the AutoFit feature for columns or rows that contain merged cells in Microsoft Excel. In addition, if the Wrap Text feature is also selected, text is not wrapped automatically.

↑ Back to the top

Cause

In Excel, you cannot use the AutoFit feature on a column that contains a cell merged with cells in other columns. Likewise, you cannot use AutoFit on a row that contains a cell merged with cells in other rows.

↑ Back to the top

Workaround

When you use merged cells, manually adjust row height and column width by using the following procedures, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2003 and earlier versions of Excel

  • On the Format menu, point to Row, and then click Height.
  • On the Format menu, point to Column, and then click Width.

Microsoft Office Excel 2007

  • On the Home tab, click
    Format in the Cells group, and then click
    Row Height.
  • On the Home tab, click
    Format in the Cells group, and then click
    Column Width.

↑ Back to the top

Keywords: kb, kbprb, kboffice2003yes, kbsweptsoltax, kbadp, kbfreshness2006, kboffice12yes

↑ Back to the top

Article Info
Article ID : 212010
Revision : 12
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 117