How to keep the width of the columns when copying?

In this lesson you can learn how to keep the width of the columns when copying data in Excel.

When you copy part or all of any table to another workbook or worksheet to another location, by default, Excel places the copied content in the cells of a standard width. If your cells are wider or narrower, you must change it back manually after copying. Let's see how to copy cells, retaining the original column width.

  1. To copy a table cell, first select it.
  2. Press the Ctrl key, hold it and press C.
  3. Set the cursor in the cell, where you want to paste the data. Press the Ctrl key, hold it and press V. The content will be pasted, but without keeping the column widths.
  4. At the bottom of the cells, which copied the contents of the table, we see the so-called smart tag. Click on the icon and the menu as shown below. Column widths will be adjusted to the pattern.

Paste Options

 

Keep Source Column Widths