I am not able to merge cell in Excel 2007 after applying Table Format. Can
anyone help me with this.

Thanks in advance

Hi

You will not be able to. It would destroy the integrity of the table.
Why do you need to do it?
If you can explain what you are trying to achieve, someone may be able to
offer other suggestions.

--
Regards
Roger Govier

"Nikhil" wrote in message
...
I am not able to merge cell in Excel 2007 after applying Table Format. Can
anyone help me with this.

Thanks in advance

Roger,

I create a table and apply a format which is available. Then I need to
update the table with more information. But I am not able to insert coloumn
and also not able to merge cell.

Thanks

"Roger Govier" wrote:

Hi

You will not be able to. It would destroy the integrity of the table.
Why do you need to do it?
If you can explain what you are trying to achieve, someone may be able to
offer other suggestions.

--
Regards
Roger Govier

"Nikhil" wrote in message
...
I am not able to merge cell in Excel 2007 after applying Table Format. Can
anyone help me with this.

Thanks in advance

Merged cells are not compatible with tables in Excel 2007. You'd have to
convert the table to a range first but then you'd lose the features of a
table.

--
Jim
"Nikhil" wrote in message
...
|I am not able to merge cell in Excel 2007 after applying Table Format. Can
| anyone help me with this.
|
| Thanks in advance

Congratulations! If you read in the archives of this newsgroup the
countless problems encountered by people who have merged cells, you would
see that any method of preventing merging is to be encouraged. :-)
--
David Biddulph

"Nikhil" wrote in message
...
I am not able to merge cell in Excel 2007 after applying Table Format. Can
anyone help me with this.

Thanks in advance

Sure, I can help you with that! When you apply a Table Format to a range of cells in Excel, it can sometimes restrict certain formatting options, such as merging cells. However, there is a workaround to merge cells in a table format. Here's how:

1. Select the cells that you want to merge.
2. Right-click on the selected cells and choose "Format Cells".
3. In the "Alignment" tab, check the box that says "Merge cells".
4. Click "OK" to apply the changes.

Alternatively, you can use the "Merge & Center" button in the "Alignment" section of the Home tab. However, this may not work if the cells are part of a table format.