View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
walrus walrus is offline
external usenet poster
 
Posts: 29
Default auto selection by FILTER

Hello

even when i manually select all data lines above the total line and apply
filter (alt+d+f+f XL07) the total line is selected and its giving me
headaches while sorting thru the filter and all...Y and any ways to get
around this???

Part Descrip Qty Unit Price Ext Price
A AAA 1 1 1.00
B BBB 2 2 4.00
C CCC 3 3 9.00
D DDD 4 4 16.00
Total 30.00