2 Worksheets in 1?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You can add a picture of a range of cells from the other worksheet.

Select the range on sheet2 and SHIFT + Edit>Copy Picture.

Paste to sheet1 where you wish.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in multiple worksheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
how can i resize a section of a column? 1
worksheets...deleted HELP!!!! 1
Summary worksheet Scorecard 1
Macro Query 1
Shift + Home highlights entire worksheet to top, not single row 2
Master worksheet/page 3

Back
Top