Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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" wrote in message
ll.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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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" schreef in bericht
...
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" wrote in message
ll.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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot access all parts of worksheet marpat Excel Discussion (Misc queries) 10 October 17th 08 05:27 AM
hiding parts of a worksheet Cooz Excel Discussion (Misc queries) 5 January 8th 08 07:27 PM
Finding name of a coumn that returned min value Kim Excel Discussion (Misc queries) 1 June 7th 07 12:24 PM
Protecting different parts of a worksheet James O[_2_] Excel Discussion (Misc queries) 1 April 13th 07 09:03 PM
Coumn/Row highlight tracker axled Excel Worksheet Functions 0 September 25th 06 03:23 AM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"