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.

XL: How to Copy Column Widths


View products that this article applies to.

Summary

In Microsoft Excel, you can copy the column width when you copy data from one range of cells to another by selecting the entire column when you copy it. You can also copy column widths separately from your data.

↑ Back to the top


More information

To copy column widths from one range of cells to another, use either of the following methods.

Method 1: Copy column widths along with your data

  1. Select the columns you want to copy.

    To select a single column, select the column heading or move to any cell in the column and press CTRL+SPACEBAR (COMMAND+SPACEBAR if you are using a Macintosh computer).

    To select more than one column:
    1. Select the first column.
    2. Hold down the SHIFT key and use the arrow keys to select the remaining columns.
  2. On the Edit menu, click Copy.
  3. Select any cell in your destination range (the range where you want to paste your data).
  4. On the Edit menu, click Paste.

Method 2: Copy the column widths separately from your data

NOTE: This method copies all of the formats, not just the column width formatting, from the selected columns to the destination range.
  1. Select the columns you want to copy.

    To select a single column, select the column heading or move to any cell in the column and press CTRL+SPACEBAR (COMMAND+SPACEBAR if you are using a Macintosh computer).

  2. To select more than one column:
    1. Select the first column.
    2. Hold down the SHIFT key and use the arrow keys to select the remaining columns.
  3. On the Edit menu, click Copy.
  4. Select any cell in your destination range (the range where you want to paste your data).
  5. On the Edit menu, click Paste Special.
  6. In the Paste Special dialog box, select the Formats option.
  7. Click OK.

↑ Back to the top


Keywords: KB61269, kbhowto

↑ Back to the top

Article Info
Article ID : 61269
Revision : 3
Created on : 9/19/2011
Published on : 9/19/2011
Exists online : False
Views : 51