I have two different excel files both are large tables that have headings for each column. Each column has a filter that has a range extended to the bottom of the table. In one file I am able to insert rows throughout the table and they can be filtered once created. In the other file I am unable to insert rows, when I right click a row the option to insert is greyed out. Can anyone help me out? I need to insert rows in this file.

​I have two different excel files both are large tables that have headings for each column. Each column has a filter that has a range extended to the bottom of the table. In one file I am able to insert rows throughout the table and they can be filtered once created. In the other file I am unable to insert rows, when I right click a row the option to insert is greyed out. Can anyone help me out? I need to insert rows in this file.  Read More

​