ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   multiple tables on the same excell worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/87244-multiple-tables-same-excell-worksheet.html)

BigD

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.

Pete_UK

multiple tables on the same excell worksheet
 
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


Gord Dibben

multiple tables on the same excell worksheet
 
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 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.




All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com