Copy and Paste Column Width in Excel

Last Updated: June 22, 2023
puneet-gogia-excel-champs

- Written by Puneet

In Excel, you have always seen that when you copy and paste some data, the cell’s width does not get pasted, and the pasted cell values may overlap the cell space.

And sometimes, users only want to copy and paste the column widths without any values to be pasted.

The good news is that Excel has the solution to this, and you can copy and paste the data, including the column width and copy and paste the column width only without the data.

This tutorial will show you how to copy and paste the column width in multiple ways.

Copy and Paste Column Width Only

To copy and paste only the column width, follow the below steps:

  1. First, select and copy the column of which width you want to copy and paste.
    select-the-column
  2. After that, go to any cell within the column where you want to paste the copied width only and then go to the “Paste” icon within the “Home” tab and then click on the “Paste Special” option.
    paste-icon-within-home-tab
  3. Or, go to any cell within the column and right-click and then click on the “Paste Special” option.
    right-click-and-paste-special-option
  4. At this point, you will get the “Paste Special” dialog box opened and select the “Column width” option.
  5. In the end, Click OK.
    select-column-width
  6. The moment, you click OK, the column width will get pasted.
    column-width-pasted

Keyboard Shortcut to Copy and Paste Column Width Only

AltESW

  1. First, go to any cell within the column of which width you want to copy and paste and press the “Ctrl + A” shortcut keys to copy that cell.
  2. After that, go to the column cell where you want to paste the copied width and press “Alt → E → S → W”, press “Enter”, and the column width will get pasted.

Copy and Paste Column Width, including the Values and Formatting

 You have always noticed when you copy and paste the data, the width of the column does not get pasted, but to paste the copied data and column width both follow the below steps:

  1. First, select and copy the data which you want to paste somewhere else in the same sheet or the new worksheet.
    select-the-data-set
  2. After that, go to the cell, where you want to paste this data and click on the “Paste” icon within the “Home” tab and then click on the “Keep Source Column Width” option.
  3. The moment you click on that option, the copied data will get pasted with the column width and  formatting if any on the copied cells.
    select-keep -source-column-width

Keyboard Shortcut to Copy and Paste Column Width Only

AltHVW

  • First, copy the data using the “Ctrl + A” shortcut keys.
  • After that, go to the cell where you want to paste the copied data along with the width and then press “Alt → H → V → W”, and the data with the column width will get pasted.

Copy and Paste Column Width Including Formatting Using Format Painter

  1. First, go to the column header and select the entire column and then click on the “Format Painter” icon within the “Home” tab.
  2. The moment, you click on “Format Painter”, your mouse cursor will get changed into a paint-brush symbol.
    paste-width-using-format-painter
  3. Now, go to the column header where you want to paste the column width including the formatting, and simply click the mouse button and it will get pasted.
    width-pasted-including-formatting