| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot delete filtered rows in excel 2007
I recently got Office 2007 and have issues deleting visible rows in a
filtered range. Before in 2003, I could highlight the entire set of rows in the filtered range and delete them. Now, the only way I can figure to do it is to just select the range of cells with data and not the entire row. This seems to be going backwards to me. Does anyone know if there is a fix or better way to do this. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cannot delete filtered rows in excel 2007
Hi Cindy
With the range selected use the shortcut Alt ; or F5SpecialVisible cells onlyOK To select only the Visible cells. Is your range a table ???? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Cindy E" wrote in message ... I recently got Office 2007 and have issues deleting visible rows in a filtered range. Before in 2003, I could highlight the entire set of rows in the filtered range and delete them. Now, the only way I can figure to do it is to just select the range of cells with data and not the entire row. This seems to be going backwards to me. Does anyone know if there is a fix or better way to do this. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cannot delete filtered rows in excel 2007
I didn't think it was a table, but when I go to the table menu it allowed me
to convert to data range and then I could delete as normal. I don't know how my spreadsheet turned into a table to begin with, but it worked. Thank you very much. "Ron de Bruin" wrote: Hi Cindy With the range selected use the shortcut Alt ; or F5SpecialVisible cells onlyOK To select only the Visible cells. Is your range a table ???? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Cindy E" wrote in message ... I recently got Office 2007 and have issues deleting visible rows in a filtered range. Before in 2003, I could highlight the entire set of rows in the filtered range and delete them. Now, the only way I can figure to do it is to just select the range of cells with data and not the entire row. This seems to be going backwards to me. Does anyone know if there is a fix or better way to do this. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cannot delete filtered rows in excel 2007
Hi Cindy
If your range is a table the activecell must be in the table as I remember correct. I always use the shortcut ( Alt ; ) to be sure I select only the visible cells in the selection. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Cindy E" wrote in message ... I didn't think it was a table, but when I go to the table menu it allowed me to convert to data range and then I could delete as normal. I don't know how my spreadsheet turned into a table to begin with, but it worked. Thank you very much. "Ron de Bruin" wrote: Hi Cindy With the range selected use the shortcut Alt ; or F5SpecialVisible cells onlyOK To select only the Visible cells. Is your range a table ???? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Cindy E" wrote in message ... I recently got Office 2007 and have issues deleting visible rows in a filtered range. Before in 2003, I could highlight the entire set of rows in the filtered range and delete them. Now, the only way I can figure to do it is to just select the range of cells with data and not the entire row. This seems to be going backwards to me. Does anyone know if there is a fix or better way to do this. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Deleting Filtered Rows | Excel Discussion (Misc queries) | |||
| Excel 2007 - Can't delete rows or columns | Excel Discussion (Misc queries) | |||
| Delete Filtered Rows in Excel 2007 | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Excel - How do I delete filtered out rows? | Excel Discussion (Misc queries) | |||
Linear Mode
