Thread: How do I only delete/clear the visible cells in a filtered list?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Merv Merv is offline
external usenet poster
  
Posts: 5
Default How do I only delete/clear the visible cells in a filtered list?
This one puzzles me. In Excel 2003, using the filter command, I could select
a range of visible cells and delete or clear the contents of those cells
without deleting or clearing the contents of the hidden cells which had been
filtered out of view. I find that the same action now in Excel 2007, causes
both visible and hidden cell data to be deleted/cleared. Question: is there
a setting to correct this?
Reply With QuoteReply With Quote