Excel 2007 Tables

[Tammy]

Hi,

I have turned a range of data into a Table, using the new "Insert Table"
tool in Excel 2007. Great new feature!!

The problem is, when I insert a new row (by tabbing from the last cell in
the last row), the formatting for the cell in the first column does not get
applied. All of the rest of the cells in that row maintain the formatting
from the row above. All of the cells in the first column above the new row
have the same formatting - there is no mixing (bold and italics, for
example).

Any suggestions on why this would be happening?

Thanks!

 

[Ron de Bruin]

Hi Tammy

I love to see your workbook to see what the problem is.
If you want you can send it to me private and i look at it tomorrow.

Maybe you like this add-in, I upload a new version today.
http://www.rondebruin.nl/table.htm

 

[Tammy]

Hi Ron,

Thanks very much for your response. Unfortunately, the data in the workbook
contains confidential information, so I can't forward it to you. I really
appreciate your offer to look it over, though!

Also, thank you for the link to your add-in - I'll read the article and see
if it's something I'll be able to use.

Some rows in the first column had Wrap Text applied to them (I used ALT+
Enter, not the Wrap Text button). Removing that did not make a difference.
And, now that I look at the data again, some of the rows in other columns
have Wrap Text applied, but formatting followed when new rows were added for
those columns.

I'm going to start from scratch on this. The data was copied from another
spreadsheet, so there may be something "hidden" that I'm just not picking up
on.

Thanks for taking the time to respond to my post!

 

[Tammy]

Hi Ron,

Just as a follow-up, I have recreated the file, and the table is working
correctly now. Something must have been hung up "behind the scenes" in the
old file.

Thanks again for your offer of help.

Have a great week!

 

[Ron de Bruin]

Hi Tammy

That's good news
Thanks for the feedback