Possible to copy row height/column width when copy format?
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

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

  1. #1
    Guest

    Default

     
    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.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Guest

    Default

    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.

  4. #4
    New Member
    Join Date
    Dec 2010
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Possible to copy row height/column width when copy format?

    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.

  5. #5
    New Member
    Join Date
    Jan 2015
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Possible to copy row height/column width when copy format?

    Quote Originally Posted by timbowyn View Post
    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...

  6. #6
    New Member
    Join Date
    Feb 2016
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Possible to copy row height/column width when copy format?

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com