multiple tables on the same excell worksheet

Is it possible to create different tables on one excell sheet. Somehow you
would have to split the sheet or create a break so you can manipulate the
cells as not to effect other cells. Kind of like have 2 pages in one.

Yes, you can do this, and, as you have deduced, you have to leave some
blank rows or blank columns between the tables so as not to get them
mixed up. Each table can be given a different name, so you can keep
track of them that way rather than by direct cell references.

Hope this helps.

Pete

As long as you realize that column widths and row heights are a property of the
entire columns and rows, not the cells.


Gord Dibben MS Excel MVP


On Sat, 6 May 2006 17:07:01 -0700, BigD <BigD@discussions.microsoft.com> wrote:

>Is it possible to create different tables on one excell sheet. Somehow you
>would have to split the sheet or create a break so you can manipulate the
>cells as not to effect other cells. Kind of like have 2 pages in one.