In Excel for Microsoft 365 on Windows, copying cells does not normally copy their column widths. To match them, copy the source range, select the destination, open Home > Paste > Paste Special, and choose Column widths; paste the cell contents separately if needed.
What Excel copies by default
Excel treats cell contents and column widths as different kinds of information. A cell contains a value, formula, or text, and may also have formatting such as a font, fill, or border. Column width, by contrast, is a property of the entire worksheet column. Copying a range of cells and pasting it elsewhere generally transfers the copied cells, but leaves the destination columns at their existing widths.
This explains a common surprise: a pasted table can have the same words, numbers, and cell formatting as the original while looking cramped or unusually spacious. If the destination columns are narrower than the source, long entries may appear cut off or spill visually into adjacent empty cells. If they are wider, the pasted table may no longer line up with nearby material.
Column width is not the same as the width of one selected cell. For example, changing the width of column B affects every cell in B, from the first row to the last. Excel cannot give B a different width for rows 1–10 and rows 11–20. This column-wide behavior matters when deciding whether to copy widths: doing so can change the layout of other information in the destination columns.
Copy column widths with Paste Special
For a normal cell-range copy, use Paste Special’s Column widths option as a separate step. The width operation maps the copied columns onto the destination columns from left to right. A range spanning three source columns applies those three widths to the three destination columns beginning at the selected destination.
- Select the source cells or range. For example, select A1:C12 if the table occupies columns A through C.
- Copy the selection with Ctrl+C on Windows.
- Select the top-left destination cell, such as E1. The destination range does not have to be the same size to transfer widths, but the number of columns determines how many destination columns are affected.
- On the Home tab, open the Paste menu and choose Paste Special.
- In the Paste Special dialog, select Column widths, then confirm. Excel changes the widths of the corresponding destination columns.
- If you have not already pasted the table itself, paste its contents or formatting as a separate operation.
For the example, the width of source column A is applied to destination column E, B to F, and C to G. The data in E:G is not replaced by the Column widths operation. It changes the layout of those columns, so check what else is already in them before you proceed.
Choose the right order for the two pastes
If you need both the cells and their widths, you can paste the cells first and then repeat Paste Special using Column widths. You can also transfer the widths first and paste the cells afterward. Either order works for the width itself; choose the cell-paste option that suits your goal, such as keeping source formatting or pasting values only.
For example, suppose a report table in A1:C12 should appear in E1:G12, but the destination should retain its own number formats. Paste the source values into E1 using the appropriate paste option, then copy A1:C12 again, select E1, and use Paste Special > Column widths. The destination values and widths now match the source, while other cell-level formatting can remain as selected during the first paste.
If you are copying into another worksheet, select the destination sheet and its top-left cell before applying Paste Special. The source and destination do not have to be on the same sheet. When moving between workbooks, keep both workbooks open while copying, and check that the destination columns are the intended ones before confirming.
When copying entire columns is an option
Another way to transfer widths is to select whole source columns by clicking their column letters, copy them, and paste into the corresponding destination column headers. This copies the columns as columns rather than only copying a cell range. It can be useful when you genuinely want a full column-level copy, including its width and cell contents or formatting.
However, whole-column copying is a broader operation than transferring widths. It can replace destination data, formulas, or formatting across the columns, including cells far below the visible table. If the destination contains anything you need to keep, do not use this method just to match the widths. Use Paste Special > Column widths instead, which is more targeted.
Before pasting whole columns, verify that the destination columns are empty or that replacing their contents is intentional. Also consider formulas that refer to destination cells and any tables or other worksheet structures in the area. A whole-column paste is not merely a shortcut for adjusting the appearance of a small range.
Set or match widths manually
If you only need one or two columns to have a particular size, entering a width manually may be quicker than copying. Select the column or columns, then use Home > Format > Column Width and enter a value. Excel applies that width to every selected column. You can also drag the boundary between column letters to adjust a width by eye.
When several columns should all use one common width, select them together before setting the value. This is different from copying a set of varied widths: if the source columns have different widths, a single manual value will make the selected destination columns uniform rather than reproducing each source width.
AutoFit is another useful choice when the objective is readability rather than an exact match. Select the columns and choose Home > Format > AutoFit Column Width, or double-click the boundary to the right of a selected column heading. Excel adjusts widths to fit content. The result may differ from the source because the destination may contain different values, fonts, or cell formatting.
Common problems and how to fix them
- The pasted table still looks different: Check that you selected Column widths in Paste Special, not a standard paste option such as Values or Formatting. Those options affect cell-level content or appearance, not the widths of the destination columns.
- The wrong columns changed: The first destination column is determined by the cell or column you selected before pasting. Undo immediately with Ctrl+Z if the change was unintended, then select the correct top-left destination and repeat the operation.
- Other information became cramped: The destination columns may contain unrelated material. Because width applies to the whole column, the source width affects that material too. Consider choosing a different destination area or setting a compromise width manually.
- Rows are still different heights: Column widths and row heights are separate layout properties. The Column widths option does not make row heights match. Adjust row heights separately if the appearance of the rows also matters.
- Text does not display exactly like the source: Matching the width does not guarantee identical display. Font, font size, wrapping, merged cells, and the contents of adjacent cells can all affect what is visible. Check those settings as well as the width.
A column width is measured in character-based units related to the workbook’s default font, not as a fixed number of screen pixels. Therefore, the same saved width can look somewhat different at different zoom levels or with different display settings. Zoom changes how large the sheet appears on screen; it does not itself change the stored column width.
Excel on Mac and Excel for the web
In Excel for Microsoft 365 on Mac, use the Paste Special command from the Home tab or the context menu, then choose Column widths if that option is shown in the dialog. Ribbon arrangement and keyboard shortcuts can differ from Windows, so the menu command is the clearest route. On Mac, Command+C copies; use the Paste Special menu rather than relying on the Windows Ctrl+Alt+V shortcut.
Excel for the web has a more limited set of paste options than the desktop application, and the available options can depend on the current interface. If Column widths is not offered in the web Paste Special choices, open the workbook in the desktop Excel app to transfer widths directly. Alternatively, set widths manually in the web app if the Column Width control is available. After using desktop Excel, save the workbook so the layout change is retained.
Frequently Asked Questions
Does normal copy and paste in Excel keep column widths?
No. A standard cell copy and paste generally transfers cells but leaves the destination columns at their existing widths. Use Paste Special > Column widths to match the source widths.
Can I copy column widths without copying the data?
Yes. Copy the source range, select the destination’s top-left cell, and choose Paste Special > Column widths. That operation transfers widths rather than replacing the destination cells’ contents.
Can I copy widths to another worksheet?
Yes. Copy the source range, switch to the destination worksheet, select the starting cell for the matching columns, and use Paste Special > Column widths. Confirm that the destination columns can safely take on the new widths.
Why did changing one pasted column affect other cells?
Column width belongs to the entire worksheet column, not just the pasted range. Every cell in that column shares its width, so unrelated content in the same destination column will also appear under the new layout.
Does Paste Special copy row heights too?
No. Column widths and row heights are separate. The Column widths option changes destination column widths only; adjust row heights separately if you need to reproduce the full layout.
Related
- Can You Open the Same Excel File Twice?
- Can You Paste in Reverse in Excel? Methods That Work
- Lock Cells in Excel: Protect and Unlock a Worksheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Page Numbers on Both Sides in Microsoft WordTo put page numbers on alternating sides in Word, turn on Different Odd & Even Pages, then place…
- How to Compare Two Excel Sheets: A Practical GuideTo compare two Excel sheets, first make sure corresponding data is in the same positions, then use a…
- Excel Row Count: Count All, Nonblank, or Visible RowsTo count the rows in an Excel range, use =ROWS(A2:A100); it returns 99 because that range contains 99…
- Excel Keyboard Shortcuts Mouse Pad: Guide to ChoosingAn Excel keyboard shortcuts mouse pad is a physical mouse pad or desk mat printed with a quick-reference…
- Excel Goal Seek May Not Find a Solution: What to DoWhen Excel says Goal Seek may not have found a solution, it means the calculation did not reach…
- How to Group Like Items in ExcelTo group like items in Excel so matching entries appear together, select your data and choose Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.