Microsoft KB Archive/61269

= XL: How to Copy Column Widths =

Article ID: 61269

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q61269





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.



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
 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:  Select the first column. Hold down the SHIFT key and use the arrow keys to select the remaining columns.  On the Edit menu, click Copy. Select any cell in your destination range (the range where you want to paste your data).</li> On the Edit menu, click Paste.</li></ol>

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.  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).

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

Additional query words: howto XL97 XL2000 xl2002 xl98 xl2001 macxl

Keywords: kbhowto KB61269

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.