|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 8th, 2008, 10:35 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
MS2007 - deleting filtered data, deletes non-visible data too
I have a data block, wish to remove rows of data. Have filtered the ones I
want to remove. High-lighting the visible ones I wish to remove - either crtl delete rows or delete to blank them and it is removing the data from the rows not visible. Have trouble also with colouring (colours hidden rows) and copying data formulars (copies formulars into hidden rows).....never had this issue in MS2003. I am saving the files in compatability mode 97_2003 - is this causing the trouble? 
|
|
#2
December 9th, 2008, 03:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
MS2007 - deleting filtered data, deletes non-visible data too
Hi Nita
If it copy all the data (there are a few reports of 2007 users) use also the shortcut Alt ; or F5SpecialVisible cells onlyOK to select only the Visible cells. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nita" wrote in message ... I have a data block, wish to remove rows of data. Have filtered the ones I want to remove. High-lighting the visible ones I wish to remove - either crtl delete rows or delete to blank them and it is removing the data from the rows not visible. Have trouble also with colouring (colours hidden rows) and copying data formulars (copies formulars into hidden rows).....never had this issue in MS2003. I am saving the files in compatability mode 97_2003 - is this causing the trouble?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
