ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Two tables? (https://www.excelbanter.com/excel-discussion-misc-queries/228982-two-tables.html)

Betty K

Two tables?
 
I have a table that acts like it's two separate tables, i.e., when I insert a
new row, the last three columns don't have the inserted row. When I look at
the table in Table Design, the first few columns are called Table1, but the
last three columns are called Table 39. Also, there is a little blue symbol
in the lower right corner of what would be the last cell of Table1 and Table
39.

How can I get this to act as if it is one table?

Roger Govier[_3_]

Two tables?
 
Hi Betty

I think it might be best to select Table39 and whilst in Design mode,
Convert to Range first.
Then, Select Table 1 and in design ModePropertiesResize Table.
--
Regards
Roger Govier

"Betty K" wrote in message
...
I have a table that acts like it's two separate tables, i.e., when I
insert a
new row, the last three columns don't have the inserted row. When I look
at
the table in Table Design, the first few columns are called Table1, but
the
last three columns are called Table 39. Also, there is a little blue
symbol
in the lower right corner of what would be the last cell of Table1 and
Table
39.

How can I get this to act as if it is one table?




All times are GMT +1. The time now is 12:25 AM.

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