I have a spreadsheet that I need to split into 2 separate tables that are
independent of each other. Is this possible? BTW - I'm a new user......
--
Eileen

Sure can. You can place the table anywhere on the sheet you want (assuming it
fits). Standard XL worksheet goes to clumn IV, and has over 65000 rows.

Genearlly, the first table is located in upper-left (A1). The better
question is, where should you place the second table? If you plan on sorting
the first table, or using AutoFilters, you should NOT place the second table
to the right of the first table. In this example, placing it a few rows below
the first table would be better.

Vice versa, if you plan on re-arranging columns of table 1, it would be
better to place table 2 to the right of table 1.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"eileen fanning" wrote:

I have a spreadsheet that I need to split into 2 separate tables that are
independent of each other. Is this possible? BTW - I'm a new user......
--
Eileen

Luke M wrote:
Sure can. You can place the table anywhere on the sheet you want (assuming it
fits). Standard XL worksheet goes to clumn IV, and has over 65000 rows.

Genearlly, the first table is located in upper-left (A1). The better
question is, where should you place the second table? If you plan on sorting
the first table, or using AutoFilters, you should NOT place the second table
to the right of the first table. In this example, placing it a few rows below
the first table would be better.

Vice versa, if you plan on re-arranging columns of table 1, it would be
better to place table 2 to the right of table 1.

Probably the best approach is to put the second table both to the right
of and below the first table so that no columns/rows of the first table
overlap the second table. You can name each table and use the "Go To"
command to view each table when needed.

Bill

In 2003 use DataListCreate List.

In 2007 use InsertTable


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 08:09:05 -0700, eileen fanning
wrote:

I have a spreadsheet that I need to split into 2 separate tables that are
independent of each other. Is this possible? BTW - I'm a new user......