Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Worksheets in 1?
I was wondering if it is at all possible to have a have two worksheets in
one? Specifically, I have a report that I have created, but someone requested a section at the top that would require completely different sized columns than the rest of the report uses. Is it possible to embed another sheet into this report so I can resize the columns without it affecting the rest of my report? Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Worksheets in 1?
It's not possible.
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "WBTKbeezy" wrote: I was wondering if it is at all possible to have a have two worksheets in one? Specifically, I have a report that I have created, but someone requested a section at the top that would require completely different sized columns than the rest of the report uses. Is it possible to embed another sheet into this report so I can resize the columns without it affecting the rest of my report? Any help is greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Worksheets in 1?
How unfortunate... thanks for letting me know.
"Dave F" wrote: It's not possible. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "WBTKbeezy" wrote: I was wondering if it is at all possible to have a have two worksheets in one? Specifically, I have a report that I have created, but someone requested a section at the top that would require completely different sized columns than the rest of the report uses. Is it possible to embed another sheet into this report so I can resize the columns without it affecting the rest of my report? Any help is greatly appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Worksheets in 1?
I'm just guessing here, but might the "merge cells" feature allow you do do
some of this? It would take some hackery, but you might get some of the features your user is requesting. "WBTKbeezy" wrote: How unfortunate... thanks for letting me know. "Dave F" wrote: It's not possible. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "WBTKbeezy" wrote: I was wondering if it is at all possible to have a have two worksheets in one? Specifically, I have a report that I have created, but someone requested a section at the top that would require completely different sized columns than the rest of the report uses. Is it possible to embed another sheet into this report so I can resize the columns without it affecting the rest of my report? Any help is greatly appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 Worksheets in 1?
You can add a picture of a range of cells from the other worksheet.
Select the range on sheet2 and SHIFT + EditCopy Picture. Paste to sheet1 where you wish. Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 07:24:24 -0800, WBTKbeezy wrote: I was wondering if it is at all possible to have a have two worksheets in one? Specifically, I have a report that I have created, but someone requested a section at the top that would require completely different sized columns than the rest of the report uses. Is it possible to embed another sheet into this report so I can resize the columns without it affecting the rest of my report? Any help is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
Across Worksheets Again | New Users to Excel | |||
Worksheets | Excel Discussion (Misc queries) | |||
Worksheets | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |