Embedding a spread sheet within a spread sheet

[cmf0106]

Is it possible to embed a spread sheet within a spread sheet?

The reason I ask is due to formatting when designing templates, I often run out of room, but if I could make the same rows/columns cells have variable width, or height I could fit more in, and one solution I see to that is embedding a spread sheet within a spread sheet so each data set can independently be modified.

please let me know if any clarification is needed, many thanks

[shg]

No, you can't.

You may be able to use the camera tool to do what you want, though. See http://www.experts-exchange.com/arti...mera-Tool.html

[ChemistB]

I find it hard to believe you run out of columns in Excel 2007 with over 16,000 columns. However, here's one way to do what you want to do. Check the attachment to see if this is what you want. If you double click on the "imbedded" data, you'll go to the source sheet so you can modify it. First you'll need to put the camera tool on your Quick Access Toolbar.

1.From the icon (upper left) click on the Excel Options Button.
2. Select Customize, then "Chose Commands from: All Commands" then find "Camera" (alphabetical order) and "Add". Then Okay. The Camera icon will appear with your quick access icons.
3. On Sheet2, set up your tables with your narrow columns or rows. On Sheet1 you'll have your wider columns.
4. Select your entire table on Sheet2 and click on the camera tool icon.
5. Go to sheet1 and click where you want this table to appear.
6. If you change data on sheet2, it will automatically change on the imbedded table.

Does this work for you?