Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: divide a sheet to allow different formating

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how do I divide a sheet in two separate parts between row 20 & 21. I want to widen the columns above 20 and not affect the ones below 21.


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A worksheet column's width is uniform.

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

    Default

    Hi gumby

    Mark is right, the column width is uniform from row 1 to row 65536. However you can merge two adjacent cells in rows 1 to 20. I assume you are designing a form where there are more columns in the bottom half than the top. The only way to simulate this is to merge some cells. Be aware though that it is not so easy to copy or paste into merged cells.

    regards
    Derek

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    too right...

    if, however, it's just for presentation purposes :

    try splitting your data ranges into two seperate sheets, making each's column widths as appropriate

    then on the "tools" toolbar, use the camera to take a snapshot of each sheet and then paste both images to a single sheet

    with a bit of acquired skill via practise, you can simulate a single sheet with different column widths......

    one caveat though, no two caveats :

    1) snapshots are limited to page size so may not be practical with large data ranges

    2) you'll be farting around more often than Terrence and Phillip before it becomes second nature....

    still, in the absence of anything more positive, this might be your only option


    :: Pharma Z - Family drugstore ::

Some videos you may like

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
  •