Two tables?

B

Betty K

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?
 
R

Roger Govier

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 Mode>Properties>Resize Table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
VBA - retrieve data on last create named range from previous inserted named range 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Retrieving info from multiple tables 1
Countif wrong in last row or two 3
Populating Cells with Table Data 1
Using INDEX and MATCH in an Array 7
Help calculating trend by colours/taking last value per month. Thanks for all efforts 0

Top