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.
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.
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.
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.
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.
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.