MrExcel.com - Your One Stop for Excel Tips & Solutions

I want to put two seperate tables in one worksheet!

Posted by J. Abney on February 01, 2000 12:18 PM

I am wanting to put two seperate tables into one worksheet. The reason for this is to have one table of data, then have another smaller table that serves as a legend. I want to be able to resize the columns in the the legend table, and not affect the column width in the data table. Hope this makes sense.

Thanks
Jon

Posted by Tom Morales on February 01, 2000 3:06 PM

Jon - One solution would be to create your "legend" in a separate, saved file. Then go to Insert/Object/Create from File. Identify the saved legend file, and you'll have a spreadsheet in a spreadsheet.
Tom