multiple tables on the same excell worksheet

B

BigD

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

Pete_UK

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
 
G

Gord Dibben

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
 
Top