Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I only delete/clear the visible cells in a filtered list?
Hi
I have just tried this with XL2007 and I get inconsistent results. Sometimes it does behave exactly like XL2003 and only clears the contents of the visible cells, and sometimes it clears everything between the first and last visible rows. Having applied the Autofilter, selected the rows required, if I right click and choose Clear Contents it "seems" to behave correctly. If I press the Delete button, it usually clears the lot. So far, I have not been able to determine exactly what conditions cause it to work consistently. -- Regards Roger Govier "Merv" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I only delete/clear the visible cells in a filtered list?
A simple test work for me
But I notice that a useful shortcut is not working in Excel 2007 Ctrl ; it select all visible cells in the selection -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Roger Govier" wrote in message ... Hi I have just tried this with XL2007 and I get inconsistent results. Sometimes it does behave exactly like XL2003 and only clears the contents of the visible cells, and sometimes it clears everything between the first and last visible rows. Having applied the Autofilter, selected the rows required, if I right click and choose Clear Contents it "seems" to behave correctly. If I press the Delete button, it usually clears the lot. So far, I have not been able to determine exactly what conditions cause it to work consistently. -- Regards Roger Govier "Merv" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I only delete/clear the visible cells in a filtered list?
I'll try it... Thanks
"Merv" wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I only delete/clear the visible cells in a filtered list?
Oops
Alt ; -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... A simple test work for me But I notice that a useful shortcut is not working in Excel 2007 Ctrl ; it select all visible cells in the selection -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Roger Govier" wrote in message ... Hi I have just tried this with XL2007 and I get inconsistent results. Sometimes it does behave exactly like XL2003 and only clears the contents of the visible cells, and sometimes it clears everything between the first and last visible rows. Having applied the Autofilter, selected the rows required, if I right click and choose Clear Contents it "seems" to behave correctly. If I press the Delete button, it usually clears the lot. So far, I have not been able to determine exactly what conditions cause it to work consistently. -- Regards Roger Govier "Merv" wrote in message ... 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I only delete/clear the visible cells in a filtered list?
After a good test
Alt ; seems to work in 2007, only if there are only visible cells in the selection in Excel 2003 you see a msgbox. You not see the msgbox in Excel 2007 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Oops Alt ; -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... A simple test work for me But I notice that a useful shortcut is not working in Excel 2007 Ctrl ; it select all visible cells in the selection -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Roger Govier" wrote in message ... Hi I have just tried this with XL2007 and I get inconsistent results. Sometimes it does behave exactly like XL2003 and only clears the contents of the visible cells, and sometimes it clears everything between the first and last visible rows. Having applied the Autofilter, selected the rows required, if I right click and choose Clear Contents it "seems" to behave correctly. If I press the Delete button, it usually clears the lot. So far, I have not been able to determine exactly what conditions cause it to work consistently. -- Regards Roger Govier "Merv" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and delete Both Dupblicate Cells in a list | New Users to Excel | |||
Count Filtered Visible Items that Match Numeric Criteria between two ranges | Excel Worksheet Functions | |||
Using List Box To Clear Cells | Excel Worksheet Functions | |||
Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
average of visible cells in a filtered range | Excel Worksheet Functions |