View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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