How to Copy Cells Data with Column Widths in Excel

If you have a spreadsheet with multiple columns that you need to copy, and you want to make sure that all columns maintain their original column widths after pasting to the destination, you can copy the column widths and apply them to other columns. This post will introduce two ways to copy and paste cell data with the same column width as the original data.

Read More: Copy and Paste Cell or Row Heights to Another in Excel

Create a table containing two columns with a width of “15” for column A and “20” for column B. In an open Excel worksheet, the default column width is 10. Now we want to copy them from the range A1:B6 to D1:E6, with the same dimensions after copying the table.

How to Copy Cells Data with Column Widths in Excel 1.png

Copy Column Widths via Paste Special Feature in Excel

To copy the width of a column or columns in Excel, you can follow these steps:

1. Select the columns whose widths you want to copy. In this example, select the range A1:B6.

How to Copy Cells Data with Column Widths in Excel 2.png

2. Press the “Ctrl+C” keys on your keyboard to copy the columns.

3. Select a cell or range where you want to apply the pasting with column widths. In this example, you can select cell D1 or range D1:E6 to paste the table.

How to Copy Cells Data with Column Widths in Excel 3.png

4. Right-click on the selection and choose “Paste Special” -> “Keep Source Column Width” from the context menu.

How to Copy Cells Data with Column Widths in Excel 4.png

After this step, the original table is copied and pasted to the destination D1:E6 with the column widths.

How to Copy Cells Data with Column Widths in Excel 5.png

Copy Column Widths via Format Painter Tool in Excel

The Format Painter tool can copy the selected row or column’s formatting and apply it to the selected row or columns. You can follow the steps below to copy column widths by Format Painter.

1. Select the columns whose width you want to copy. Click on the column index on the column header to select the entire column. In this example, hold down the mouse and select column indexes A and B by dragging the mouse, then these two columns are selected.

How to Copy Cells Data with Column Widths in Excel 5.png

2. Click on the “Format Painter” button in the “Clipboard” group on the “Home” tab of the Excel ribbon. This button looks like a paintbrush.

How to Copy Cells Data with Column Widths in Excel 7.png

3. Click on the column or columns where you want to apply the same widths. In this example, hold down the mouse and select the D and E column indexes by dragging the mouse so that these two columns are selected. This step will apply the copied width to the selected columns.

How to Copy Cells Data with Column Widths in Excel 7.png

4. You can then use the normal “Copy” and “Paste” functions to copy the cell values to the destination with the same column width as the source table.

How to Copy Cells Data with Column Widths in Excel 9

How to Copy and Paste Cell or Row Heights to Another in Excel

Sometimes we need to adjust the row heights in our worksheets to ensure that consistent row heights can make Excel spreadsheets look more organized and visually appealing. If the rows are not evenly sized, the data may not align properly and can make it difficult to read. In this post, we will introduce some ways to copy the row height in an Excel worksheet to another row.

Read More: Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel

Copy and Paste Row Heights via Copying the Row Height Value

You may have tried to copy the row heights through Excel’s special paste feature. There is no such option to paste the row heights, only the column widths included.

By checking the row height in Excel, you can copy the row height number and copy it to the row height when you adjust another row. You can do this by following these steps.

Step1: Select the row(s) whose height you want to check. You can do this by clicking on the row number on the left-hand side of the worksheet.

How to Copy and Paste Cell or Row Heights to Another in Excel 1.png

Step2: Right-click on the selected row(s) and click on “Row Height” in the context menu.

How to Copy and Paste Cell or Row Heights to Another in Excel 2.png

Step3: In the “Row Height” dialog box, the “Row height” field will display the row height. In this example, the row height is “60”, you can also change the row height in this dialog box if you need to.

Step4: Copy the “Row height” number and click “OK” to close the dialog box.

How to Copy and Paste Cell or Row Heights to Another in Excel 3.png

Step5: Select another row whose height you want to pasted the row height. Click on the row number to select the entire row.

Step6: Right-click on the selected row(s) and click on “Row Height” in the context menu. Before copying the row height, the current row height is displayed in row height field.

How to Copy and Paste Cell or Row Heights to Another in Excel 4.png

Step7: Press “Ctrl+V” to paste the row height value we copied from row 1.

How to Copy and Paste Cell or Row Heights to Another in Excel 5.png

After all above steps, row height is copied and applied to row 2 properly.

How to Copy and Paste Cell or Row Heights to Another in Excel 6.png

Copy and Paste Row Heights via Using the Format Painter

Another way to check the row height is to use the “Format Painter” tool. Here are the steps:

Step1: Click on the row number to select the row whose height you want to copy.

How to Copy and Paste Cell or Row Heights to Another in Excel 7.png

Step2: Click on the “Format Painter” button in the “Home” tab of the Excel ribbon.

How to Copy and Paste Cell or Row Heights to Another in Excel 8.png

Step3: Click on another row number to apply the copied row height. The height of the selected row will change to match the height of the copied row, allowing you to visually compare the two row heights.

How to Copy and Paste Cell or Row Heights to Another in Excel 9.png

Conclusion

In summary, checking row height can help make your Excel spreadsheets more visually appealing, easier to read, and more functional for various tasks such as printing, filtering, sorting, and merging cells. After reading the post, you can adjust your row heights in a more convenient and accurate way to keep them consistent.

How to Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel

If you have a table or worksheet where you have already set up the column widths and row heights to your desired dimensions, you can use the copy and paste technique to quickly apply the same sizes to other cells or ranges, or even other worksheets or workbooks. This can help maintain a consistent and professional appearance throughout the worksheet or workbook.

In this post, we introduced some ways to copy and paste cells to the destination in another worksheet or workbook by copying the column width or row height as well. Let’s get started.

Read More: Copy and Paste Cell or Row Heights to Another in Excel

Copy and Paste Cell Column Widths in Another Worksheet or Workbook

When copying a table to a location in another worksheet or workbook via the traditional copy and paste function, only the values are copied to the destination, without copying the formatting, style or size, etc.

If a table with wide column widths is copied to a location with only narrow column widths, the copied values are not fully displayed in the columns and we must manually adjust the column widths.

How to Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel

In fact, we can now paste the copied table via “Special Paste” -> “Function” and include the column width correctly.

Here are the steps.

Step1: Select the cells whose sizes you want to copy.

Step2: Right-click on the selected cells and choose “Copy” from the context menu, or press “Ctrl+C” on your keyboard.

Step3: Select the destination cells where you want to paste the sizes. You can select a single cell, a range of cells, or even an entire row or column.

Step4: Right-click on the destination cells and choose “Paste Special” -> “Keep Source Column Widths” from the context menu.

How to Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel

Or press “Ctrl+Alt+V” on your keyboard to open “Paste Special” dialog box, and check on “Column widths” checkbox, and click “OK” to apply the changes.

How to Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel

Copy and Paste Cell Column Widths and Row Heights in Another Worksheet or Workbook

When copying and pasting cells, there is no such a way to allow copying the row height. But we can still do it in a special way.

Here are the steps:

Step1. Open the worksheet that contains the table you want to copy.

Step2. Click on the worksheet tab at the bottom of the screen to activate it.

Step3. Click on the “Select All” button located at the top-left corner of the worksheet, where the column and row headers meet. This selects all cells in the worksheet.

How to Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel

Step4. Right-click on any selected cell and choose “Copy” from the context menu, or press “Ctrl + C” on your keyboard.

Step5. Click on the worksheet tab or workbook where you want to paste the copied cells.

Step6. Click on the “Select All” button, press “Ctrl + V” to copy all cells with cell sizes from source worksheet to the new worksheet. In this way, the column widths and row heights are copied correctly to their destinations in the desired dimensions.

How to Copy and Paste Cell Sizes to Another Worksheet or Workbook in Excel