#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
look up tables and getting rid of the #N/A smiley61799 New Users to Excel 3 April 20th 09 05:40 PM
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
Which Tax Tables to use? [email protected] Excel Discussion (Misc queries) 6 July 8th 06 05:19 PM
ref tables Colin McLure Setting up and Configuration of Excel 0 December 21st 04 04:40 PM
Tables fastcar Excel Worksheet Functions 2 November 14th 04 07:20 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"