Mar 31 2022 04:06 AM - edited Mar 31 2022 04:07 AM
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?
Any help or advice is appreciated. :)
Mar 31 2022 05:25 AM - edited Mar 31 2022 05:44 AM
You want resizing a table in Excel without losing format.
The table size is not restricted to 776 rows it can be further increased upto last row i.e. 1048576 of excel sheet.
Now you can choose either of the option to increase the size of your table.
Option A
Option B