Copying Entire Rows and Columns Copies Formatting in Excel

Last reviewed: November 3, 1994
Article ID: Q69982

The information in this article applies to:

Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

SUMMARY

When copying or sorting information in Microsoft Excel, if you select the entire column or row, the formatting associated with the selection is copied also.

This includes cell formatting, font formatting, column width (if column is selected), row height (if row is selected), and number formatting.

MORE INFORMATION

If you do not select the entire column or the entire row when you select a range to copy or sort, the column width and the row height are not preserved. However, if the copy or sort data contains a cell with a text string as the contents and the text is wrapped and aligned, when that record copies or sorts to its new position, the taller row height is carried to the new position.

KBCategory: kbusage
KBSubcategory:
Additional reference words: 5.00 3.0 3.00 4.0 4.00 heights widths sort

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.