Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot access all parts of worksheet | Excel Discussion (Misc queries) | |||
hiding parts of a worksheet | Excel Discussion (Misc queries) | |||
Finding name of a coumn that returned min value | Excel Discussion (Misc queries) | |||
Protecting different parts of a worksheet | Excel Discussion (Misc queries) | |||
Coumn/Row highlight tracker | Excel Worksheet Functions |