I don't see any difference between versions. When I set an autofilter and
delete entire rows, only the visible rows are deleted. When I cut/paste the
entire range selected, including hidden rows, is moved. In the latter case,
for either version, if you wanted just visible cells to be moved, you'd have
to do a {F5}, Special, Visible Cells Only first.

--
Jim
"SEF" wrote in message
...
| Hello,
|
| In the Excel 2003 I used the Data filter feature to cut or remove selected
| rows from my sheet. The expected result the remains rows would remain in
the
| sheet as occurred with Excel 2003.
|
| With Excel 2007, if I cut or remove the selected rows, when I uncheck the
| filter the sheet is blank. How do I keep Excel 2007 from removing just
the
| rows that I cut or delete and have all remaining rows stay on the sheet.
|
| Thanks for any help,
|
| Steve
|