I have a table in an Excel worksheet with data which is 776 rows long. From row 777 and on I continued writing data but it is not included in the table. Now when I want to filter the data it only filters through the information included within those 776 rows and not the rest. The problem is when I try to resize the table and include all the rows that are not in the table, the cells lose format (color, etc. ). Is there a way to include the information in the table so I can use the filter tool without losing format?