Possible to copy row height/column width when copy format?

[Guest]

When duplicating a section of a workbook, is there a way to copy the row heights and column widths as well as the cell formats. Every method I've tried, I can get the cell format(borders,bold print,currency,etc.) but the rows and columns have to be sized manually.

 

[Derek]

Hi
If you're using Excel 2000 try this:
Select the entire rows you want to copy, when you paste them to a new sheet the rows heights should adjust.
Now copy the columns whose widths you want to repeat. When you paste, use Paste Special,Column Widths.
Hope this helps
Regards
Derek

 

[Guest]

Thank you. It is at least 90% solution. Still have to cut and paste data on a second pass but that is much easier than sizing hundreds of rows and dozens of columns.

 

[timbowyn]

On your original excel worksheet, there is a blank square located above the "1" and to the left of "A" column and row identifiers. Right click on this blank square, choose copy. This will copy everything on your original sheet. Now go to the new sheet. Right click on the blank square, choose paste. This will copy and paste everything exactly as it was on the original sheet, columns, rows, formatting.

 

[Tanabaj]

On your original excel worksheet, there is a blank square located above the "1" and to the left of "A" column and row identifiers. Right click on this blank square, choose copy. This will copy everything on your original sheet. Now go to the new sheet. Right click on the blank square, choose paste. This will copy and paste everything exactly as it was on the original sheet, columns, rows, formatting.

Thank you! It's really an easy thing to do, but I would have never figured it out...

 

[Lano01]

Hi,

Looking at this I think the original question is to just take the row and column widths - nothing else....the solutions offered will take content as well.

I think I may have the solution to this at least for the column width - for some reason it does not list row heights!! It involves going a stage further than that given here in "paste special" options....

Do as suggested above to copy using that corner square but in the paste go "Paste Special" - then there is another "Paste Special..." option at the bottom of teh box that appears - which leads to a series of buttons to select your option...choose "column widths"...ok...voila...

Hope that at least covers part of it....I usually find that the row heights will be variable in any event in the longer term....

Cheers

Lano