Cannot add a row to a table

[JenniferMurphy]

I have a sheet with two tables, side by side. They are too large to post as a minisheet, so I'll try my best to describe the problem. I have been using the sheet for at least a year with no problems. The Item table on the left contains a list of items. The primary column is Title. The Log table on the right contains events with those items. It also has a Title column. I rarely add a row to the Item table, but I add a row to the Log table each time I complete some work on an item. I do that by adding a row to the top of the Log table. I right-click the top row, select Insert, and then Table Rows Above.

Yesterday, I fiddled around with using Filter to compress the Log table to just the titles in the top row of the Title table. When I went to add a row to the Log table, I was no longer able to add a row to just that table. The Insert option now says Entire Sheet Row.

Can anyone suggest what I did and how I can fix it?

 

[HighAndWilder]

I have a sheet with two tables, side by side. They are too large to post as a minisheet, so I'll try my best to describe the problem. I have been using the sheet for at least a year with no problems. The Item table on the left contains a list of items. The primary column is Title. The Log table on the right contains events with those items. It also has a Title column. I rarely add a row to the Item table, but I add a row to the Log table each time I complete some work on an item. I do that by adding a row to the top of the Log table. I right-click the top row, select Insert, and then Table Rows Above.

Yesterday, I fiddled around with using Filter to compress the Log table to just the titles in the top row of the Title table. When I went to add a row to the Log table, I was no longer able to add a row to just that table. The Insert option now says Entire Sheet Row.

Can anyone suggest what I did and how I can fix it?

When you say 'side by side', are there are columns between the tables?

 

[JenniferMurphy]

When you say 'side by side', are there are columns between the tables?

Yes. The Title table is in columns B:S. The Log table is in columns Z:AJ. There are 6 columns between them.

 

[JenniferMurphy]

I just found the problem. It happened right after I had been playing with filtering. So I thought I'd try clearing all filters. I just did that again. This time I noticed that right-clicking in a column and selecting Filter only clear filters for that column. So I tried it again for other column and discovered that a filter was still in effect. I cleared that and now I can add a row just to the Log table.

 

[JenniferMurphy]

Is there a way to clear all filters in all columns of a table with one command or do I have to do each column individually? Or is there a way to clear all filter in an entire sheet with one command?

Should I mark my reply above as the answer? It seems a little self-serving, but it's good to have an answer.

 

[Asbestos_Jen]

The filters option on the ribbon does it (excel 2007, so presumably later versions as well).

 

[JenniferMurphy]

That seems to work, thanks. I thought I tried that, but apparently not.