In Excel, I was trying to copy a part of a page into another worksheet. However, I want to apply the same value of column widths and row heights in the new worksheet. I have figured out though how I could copy the value of column widths and how do I copy the value of row heights as well? Any kind of help will be appreciated.
Hello Alekim,
Just follow the instructions below to solve your problem:
Suppose, you need to copy the elements from row 1 to row 6. Now select row 1 and drag down to row 6 holding left mouse button. Now release your mouse and right click on the selected row and Copy it. Like this:
Now go to your desired worksheet where you want to paste the same thing at same state. Select the rows where you want to paste your data. Now right click on your selected area and click “Paste Special”.
You will find a message like this and click “OK”.
Now you will able to paste your data at the same value of column widths and row heights in the new worksheet.
Thanks.
You can wrap the cells that you have in the original worksheet before you copy them to the new worksheet as follows:
In case that does not work, you will need to adjust the row heights and columns manually.
Regards,
Thompson Locker
