View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fuadramsey
 
Posts: n/a
Default When creating a formula how do you select only visible cells


I know you can use the "select only visible cells" option to select a
group of visable cells when filtered or hidden, but this does not seem
to work when I am entering a formula.
I hit the equall button and then the average button, here I can select
cells with the mouse(on a filtered sheet), but when I hit the "select
only visable cells" button, nothing changes


--
fuadramsey
------------------------------------------------------------------------
fuadramsey's Profile: http://www.excelforum.com/member.php...o&userid=35352
View this thread: http://www.excelforum.com/showthread...hreadid=551252