Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look up tables and getting rid of the #N/A | New Users to Excel | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Which Tax Tables to use? | Excel Discussion (Misc queries) | |||
ref tables | Setting up and Configuration of Excel | |||
Tables | Excel Worksheet Functions |