How to remove the color of the partial rows which is `Convert(ed) to Range' from Table

Hello Friends

In Excel 2010 i have made huge tables to `Convert to Range'. Now i need to remove the zig zag row colors automatically created in excel table. Option is there to clear that before making the `Convert to Range'. But i have already converted to range again i need to regenerate it will take huge time.

After `Convert to Range' is there any way to remove the zig zag colors in partial rows. Rows are being changed with Dark and light colos (Say dark green then next row is light green or Say dark orange then next row is light orange or Say dark blue then next row is light blue).

Thanks in advance

Hi,

Can you select the range manually and use no fill??

Yes it is working fine.

Thank you