+ Reply to Thread
Results 1 to 2 of 2

Excel: copy grid, widths & heights down page: heights wrong! why?

  1. #1
    K
    Guest

    Excel: copy grid, widths & heights down page: heights wrong! why?

    I "paste special" to get correct widths, but heights are all same (default).
    I have a worksheet I made with varying widths and column heights and want to
    copy the entire grid to other places on the same page.
    Why do the heights not copy??
    Thank You for your help.
    K

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    I assume the row height is linked to the entire row, not just the one cell. If you select and copy the entire row, then paste the row in a new location, the row heights are copied

    If you use paste\special \formats, it will just copy the row heights and not the data

    Matt

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1