Separate tables on one tab

[eileen fanning]

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......

 

[Luke M]

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.

 

[Bill Sharpe]

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

 

[Gord Dibben]

In 2003 use Data>List>Create List.

In 2007 use Insert>Table


Gord Dibben MS Excel MVP