View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SEF SEF is offline
external usenet poster
 
Posts: 5
Default Excel 2007 Data Filter - When using cut it clears all data

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