Prevent change in cell format by pasting data

[ssdhutekar]

Hi,

I'm using Excel 2010. Is there any solution which cover requirements given below.

1) I've converted a range in to table format (using Format as Table)
2) Need to Prevent pasting on data validation cell.
3) Need to Prevent change in cell format after pasting data (other than data validation cells as mentioned above) from same workbook or other workbook
4) Need to insert row in the table as per requirement.

Pls share any solution on this.

Thanks

Sarang Dhutekar

[arlu1201]

Hello ssdhutekar,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[ssdhutekar]

Thanks a lot...