Deleting or modifying rows that are above and below a hidden row in a filtered Excel 2007 worksheet also deletes or modifies the hidden row

In Microsoft Office Excel 2007, you apply a filter to a worksheet by selecting the header to hide a row. This worksheet has not been saved. If you then delete or modify the rows in the worksheet that are above and below the hidden row, the hidden row is also deleted or modified. This issue occurs when you select only the range headers, and then you turn on AutoFilters.

This issue occurs in the following scenarios after you filter the data by selecting the range headers:

• Row deletion: Deleting the selected range would delete the hidden rows between this range.
• Fill: Filling data in the selected range would fill even the hidden rows between this range.
• Copy/Paste: Copying and then pasting the range of cells will paste even the hidden rows.
• Formatting: Formatting the selected range would format the hidden rows also.

To resolve this issue, apply the hotfix that is described in Microsoft Knowledge Base article 948944.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

To work around this issue after you apply the filter, save the workbook, and then close and reopen the workbook.

Additionally, instead of selecting only the range header and turning on AutoFilter, select the whole range or any one cell within the range, and then turn on AutoFilters.

To apply a filter in an Excel 2007 worksheet, do the following:

1. On the Home tab, click Sort & Filter in the Editing group.
2. Click Filter.

Note You do not have to select the first row to apply the filter.

For more information about how to apply a filter, click Microsoft Office Excel Help or press F1, type filter in the Search box, and then click Search.