Embedding a spread sheet within a spread sheet

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?