Issue With Pasting on Filtered Rows in a Excel Table : MAC

1. Check the filter status: Make sure you have applied the filter correctly and that only the target rows are displayed.
Click the Filter icon in the table title bar to check the filter conditions. 
2. Use the Paste to Visible Cells feature: Copy the data to be pasted.
Select the filtered visible cell area.
Right-click on the selected area and select “Paste into Visible Cells”. 
3. Paste using shortcut keys: Copy the data to be pasted.
Select the filtered visible cell area.
Press Command + Option + V, and then select “Paste to Visible Cells”. 
4. Paste after unfiltering: unfilter and show all rows.
Paste the data into the target area.
Reapply the filter.
5. Use a secondary column: Add a secondary column to the table to mark the visible rows after filtering.
Use formula or conditional formatting to mark the visible rows.
Paste data into the marked visible rows.
6. Contact Microsoft Support: If none of the above methods work, it is recommended to contact Microsoft support team with detailed error messages and screenshots for further assistance.