So when I applied a table with headers to my selected range (A14:G42) in my G column an #SPILL! error appears . I do have a formula in that column (=IF(A15:A42<75,"Order","OK"). I did use the Excel help options and it instructs me to Convert To Range. But when I do that it takes away my Design Table and all my options to format my table (like the total row option). I cant seem to figure out how to correct this error. Help Please.