+ Reply to Thread
Results 1 to 3 of 3

How to have different columnwidth for same coumn in several parts within one worksheet?

  1. #1
    Oscar
    Guest

    How to have different columnwidth for same coumn in several parts within one worksheet?

    Is it possible to have a break within a worksheet which enables to have
    another column width after the breakpoint? In this way I could have a
    worksheet with several sections which have an independent formatting (like
    MS Word) and that would be great for reporting features.



  2. #2
    Tom Ogilvy
    Guest

    Re: How to have different columnwidth for same coumn in several parts within one worksheet?

    No, that isn't supported. The closest you could get would be to simulate
    such an organization by using merge cells, but this would be pretty
    cumbersome in my opinion.

    Another thing you could do is use separate sheets for portions of your
    report. copy the appropriate range in one of the sheets and go to the sheet
    you want to print out. Hold down the shift key and select paste picture
    link. This will place a linked picture of the worksheet on the sheet to be
    printed. Repeat for other portions of the report.


    --
    Regards,
    Tom Ogilvy

    "Oscar" <oku@xs4all.nl> wrote in message
    news:4247f9a1$0$20116$e4fe514c@dreader18.news.xs4all.nl...
    > Is it possible to have a break within a worksheet which enables to have
    > another column width after the breakpoint? In this way I could have a
    > worksheet with several sections which have an independent formatting (like
    > MS Word) and that would be great for reporting features.
    >
    >




  3. #3
    Oscar
    Guest

    Re: How to have different columnwidth for same coumn in several parts within one worksheet?

    Thank you very much Tom!
    As it was meaned for printing reports purposes the pasting of picture method
    was a good solution.

    regards,
    Oscar


    "Tom Ogilvy" <twogilvy@msn.com> schreef in bericht
    news:%23wUBuN5MFHA.2136@TK2MSFTNGP14.phx.gbl...
    > No, that isn't supported. The closest you could get would be to simulate
    > such an organization by using merge cells, but this would be pretty
    > cumbersome in my opinion.
    >
    > Another thing you could do is use separate sheets for portions of your
    > report. copy the appropriate range in one of the sheets and go to the
    > sheet
    > you want to print out. Hold down the shift key and select paste picture
    > link. This will place a linked picture of the worksheet on the sheet to
    > be
    > printed. Repeat for other portions of the report.
    >
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    > "Oscar" <oku@xs4all.nl> wrote in message
    > news:4247f9a1$0$20116$e4fe514c@dreader18.news.xs4all.nl...
    >> Is it possible to have a break within a worksheet which enables to have
    >> another column width after the breakpoint? In this way I could have a
    >> worksheet with several sections which have an independent formatting
    >> (like
    >> MS Word) and that would be great for reporting features.
    >>
    >>

    >
    >




+ 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